--完整備份(append)--
BACKUP DATABASE "db" TO DISK='db.bak' WITH NAME='Full Database Backup', NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD, STATS=10
--差異備份(append)--
BACKUP DATABASE "db" TO DISK='db.bak' WITH NAME='Differential Database Backup', DIFFERENTIAL, NOFORMAT, NOINIT, SKIP, NOREWIND, NOUNLOAD, STATS=10
--列出backup set--
RESTORE HEADERONLY FROM DISK='db.bak'
使用欄位:Position
--列出第一個backup set的檔名--
RESTORE FILELISTONLY FROM DISK='db.bak'
使用欄位:LogicalName、PhysicalName、Type,Type可能是D或L
--還原至另一個資料庫--
RESTORE DATABASE "db" FROM DISK='db.bak' WITH FILE=1, MOVE 'orig_LogicalName' TO 'db.mdf', MOVE 'orig_LogicalName_log' TO 'db_log.LDF', NORECOVERY, NOUNLOAD, STATS=10
RESTORE DATABASE "db" FROM DISK='db.bak' WITH FILE=2, MOVE 'orig_LogicalName' TO 'db.mdf', MOVE 'orig_LogicalName_log' TO 'db_log.LDF', NOUNLOAD, STATS=10
還原時,除了最後一個backup set,都要NORECOVERY參數