| 
  • Increase font size
  • Decrease font size
  • Default font size
  • default color
  • red color
  • green color
香农数据安全在线
Jul 30th
首 页 arrow 数据库 arrow MSSQL arrow SQLServer基于时间点的恢复

SQLServer基于时间点的恢复 输出PDF
作者： 转载   
2007-11-30
Alter database message set offline with rollback immediate;
restore database message from disk='d:\message_db_200708280214.BAK' with replace,norecovery
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270215.TRN'
WITH NORECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270230.TRN'
WITH NORECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270245.TRN'
WITH NORECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270300.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270315.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270330.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270345.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270400.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270415.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270430.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270445.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270500.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270515.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270530.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270545.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270600.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270615.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270630.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270645.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270700.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270715.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270830.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270845.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270900.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270915.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270930.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708270945.TRN'
WITH RECOVERY
RESTORE LOG message
FROM DISK = 'd:\mess\message_tlog_200708271000.TRN'
WITH RECOVERY
alter database message set online;

Tags

查看所有标签

 
< 上一篇   下一篇 >

 

相关文章