從備份檔案還原資料庫

CMS_backup_200810260300.bak    -為2008102603完整備份檔案

CMS_backup_200811041400.bak    -為2008110414的差異備份檔案

CMS_backup_200811091400.bak    -為2008110914的差異備份檔案

還原，到2008110414時間點資料

restore database CMS

from disk='F:/cms/CMS_backup_200810260300.bak'

with norecovery

restore database CMS

from disk='F:/cms/CMS_backup_200811041400.bak '

with recovery

還原，到2008110914時間點資料

restore database CMS

from disk='F:/cms/CMS_backup_200810260300.bak'

with norecovery

restore database CMS

from disk='F:/cms/CMS_backup_200811091400.bak '

with recovery