--完整備份 Backup Database db_database To disk='D:\Backup\db_database_Full.bak' --差異備份 Backup Database db_database To disk='D:\Backup\db_database_Diff.bak' With Differential 解釋如下: NAME = 'Full Backup of MyNwind' --這個是備注,隨便寫。 還原命令: USE master GO RESTORE DATABASE test_wt FROM disk = 'c:\test_wt' GO