脚本宝典收集整理的这篇文章主要介绍了如何恢复数据库备份到一个已存在的正在使用的数据库上,脚本宝典觉得挺不错的,现在分享给大家,也给大家做个参考。
USE&nbs
p;master -- (Can&
#146;t s
IT in the database whilst its b
eing re
Stored!)
GO
ALTER DATABASE 
;myDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
-- Restore Full Backup
RESTORE DATABASE MyDatabase
From disk = x:\MS
SQL\BACKUP\MyBackupFilen
ame_Full.BAK
WITH
REPLACE,
NORECOVERY, -- Use if more T/
LOGs to recover
-- RECOVERY, -- Use if NO more T/Logs to recover
statS = 10, -- Show
PRogress (every 10%)
MOVE MyDatabase_Data TO x:\MSSQL\DATA\MyDatabase.m
DF,
MOVE MyDatabase_Log TO x:\MSSQL\DATA\MyDatabase.ldf
GO
-- Optional restore Differential Backup
RESTORE DATABASE MyDatabase
F
rom DISK = x:\MSSQL\BACKUP\MyDatabase_Diff.BAK
WITH
-- RECOVERY -- Use if NO more file to recover
NORECOVERY -- Use if there are T/Logs to recover
GO
-- Optional restore Transaction Log Backup
RESTORE DATABASE MyDatabase
FROM DISK = x:\MSSQL\BACKUP\MyDatabase_
yyyymmdd_hhmm_Trans.BAK
WITH
-- RECOVERY -- Use if NO more T/Logs to recover
NORECOVERY -- Use if more T/Logs to recover
GO
-- Set the database ready for use (after all backups have been resto
red)
RESTORE DATABASE MyDatabase RECOVERY
GO
--
rename log
ical names (only needed if restoring from a backup for a Different database):
ALTER DATABASE MyDatabase
MODIFY FILE (NAME = OrigDatabase_Data, NEWNAME = MyDatabase_data)
GO
ALTER DATABASE MyDatabase
MODIFY FILE (NAME = OrigDatabase_Log, NEWNAME = MyDatabase_log)
GO
脚本宝典总结
以上是脚本宝典为你收集整理的如何恢复数据库备份到一个已存在的正在使用的数据库上全部内容,希望文章能够帮你解决如何恢复数据库备份到一个已存在的正在使用的数据库上所遇到的问题。
如果觉得脚本宝典网站内容还不错,欢迎将脚本宝典推荐好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。