資料庫將會留置於載入狀態以便讓您套用另一個記錄檔檔

這個記錄檔檔案包含指定的時間點之前所記錄的資料錄。資料庫將會留置於載入狀態以便讓您套用另一個記錄檔
是由於SQL restore log stopat的時間不在該FILE數上
查詢一下該FILE集要Stopat點的檔案數
就可以啦


restore database KM from disk='c:\Backup\SQL\KM-Full-22-3.BAK' with norecovery
GO
restore log KM from disk='c:\Backup\SQL\KM-Log-22-3.BAK'
With FILE =1,NORECOVERY
GO
restore log KM from disk='c:\Backup\SQL\KM-Log-22-3.BAK'
With FILE =2,NORECOVERY
GO
restore log KM from disk='c:\Backup\SQL\KM-Log-22-3.BAK'
With FILE = 3 ,stopat='2007/5/30 16:10:00',RECOVERY