--摘自博客园的桦仔 --模仿灾难发生时还原adventurework数据库示例stopat 已放博客园BACKUP DATABASE AdventureWorks TO DISK= 'D:\MSSQL\Databackup\AdventureWorks.bak'BACKUP LOG AdventureWorks TO DISK ='D:\MSSQL\Databackup\AdventureWorks.trn' GO --灾难发生后,试图创建一个尾日志备份 BACKUP LOG AdventureWorks TO DISK='D:\MSSQL\Databackup\AdventureWorkstail.trn' WITH norecovery; GO -------------------------------------- --用界面的话这两步一起完成 --从备份恢复一个全备份 RESTORE DATABASE AdventureWorks FROM DISK ='D:\MSSQL\Databackup\AdventureWorks.bak' WITH FILE=1,NORECOVERY--从备份中恢复一个正常的日志备份 RESTORE LOG AdventureWorks FROM DISK ='D:\MSSQL\Databackup\AdventureWorks.trn' WITH NORECOVERY;----------------------------------------------------------------用stopat 恢复尾日志备份 RESTORE LOG AdventureWorks FROM DISK='D:\MSSQL\Databackup\AdventureWorkstail.trn' WITH STOPAT='2012 20:59:00', RECOVERY; GO
这里有
--模仿灾难发生时还原adventurework数据库示例stopat 已放博客园BACKUP DATABASE AdventureWorks
TO DISK= 'D:\MSSQL\Databackup\AdventureWorks.bak'BACKUP LOG AdventureWorks
TO DISK ='D:\MSSQL\Databackup\AdventureWorks.trn'
GO
--灾难发生后,试图创建一个尾日志备份
BACKUP LOG AdventureWorks
TO DISK='D:\MSSQL\Databackup\AdventureWorkstail.trn'
WITH norecovery;
GO
--------------------------------------
--用界面的话这两步一起完成
--从备份恢复一个全备份
RESTORE DATABASE AdventureWorks
FROM DISK ='D:\MSSQL\Databackup\AdventureWorks.bak'
WITH FILE=1,NORECOVERY--从备份中恢复一个正常的日志备份
RESTORE LOG AdventureWorks
FROM DISK ='D:\MSSQL\Databackup\AdventureWorks.trn'
WITH NORECOVERY;----------------------------------------------------------------用stopat 恢复尾日志备份
RESTORE LOG AdventureWorks
FROM DISK='D:\MSSQL\Databackup\AdventureWorkstail.trn'
WITH STOPAT='2012 20:59:00',
RECOVERY;
GO
1、备份日志
2、单独一个环境或实例(操作),还原昨天备份+还原今天日志备份指定还原时间点.
3、把还原的数据新增到当前实例DB里如果不是完整的情况下
用LogExplore工具反向操作征生成语句,直接在DB里执行