**************************************************/
/* 功能:SQL Server备份 */
/* 作者:贾桂军 */
/* 日期:2008年6月10日 */
/**************************************************/
--完整恢复,更改存放路径
USE Master
GO
RESTORE DATABASE [db] FROM [db_bak]
WITH FILE = 1,
MOVE N'db' TO N'd:\db.mdf',
MOVE N'db_log' TO N'd:\db_log.LDF',
NORECOVERY, NOUNLOAD, STATS = 10
GO
--差异恢复,更改存放路径
USE Master
GO
RESTORE DATABASE [db] FROM [db_bak]
WITH FILE = 2,
MOVE N'db' TO N'd:\db.mdf',
MOVE N'db_log' TO N'd:\db_log.LDF',
NORECOVERY, NOUNLOAD, STATS = 10
GO
--日志恢复
USE Master
GO
RESTORE LOG [db] FROM [db_bak]
WITH FILE = 3,
NORECOVERY, NOUNLOAD, STATS = 10
GO --还能继续还原
--恢复日志到可以使用
RESTORE LOG [db] FROM [db_bak]
WITH FILE = 4,
NORECOVERY, NOUNLOAD, STATS = 10
GO
RESTORE LOG [db] FROM [db_bak]
WITH FILE = 5,
NOUNLOAD, STATS = 10
GO
转载于:https://blog.51cto.com/77719008/477886