完整備份 與 交易日誌備份的還原測試
restore database cross_db from cross_device with norecovery
restore log cross_db from cross_log_device with file = 1 , norecovery
restore log cross_db from cross_log_device with file = 2 , norecovery
restore log cross_db from cross_log_device with file = 3, recovery
整完備份 與 交易日誌備份的還原到某個時間點方式
restore database cross_db from cross_device with norecovery
restore log cross_db from cross_log_device with file = 1 , norecovery
restore log cross_db from cross_log_device with file = 2 , norecovery
restore log cross_db from cross_log_device with file = 3, recovery, stopat = Jun 3, 2000 4:53 PM
ps: 檢查交易日誌的時間範圍
restore headeronly from cross_log_device
ps: 如果還原模式是 simple 是無法備份日誌，必需修改為 full 模式
alter database cross_db set recovery full
留言