不就是個blog

--完整備份(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參數