MSSQL常用备份还原脚本

--完整备份
Backup Database pubs To disk='d:\Backup\pubs.bak' 

--差异备份
Backup Database pubs To disk='d:\Backup\pubs_Diff_20070908.bak' With Differential


--完整还原
RESTORE DATABASE pubs FROM DISK = 'd:\Backup\pubs_Full_20070908.bak' WITH PASSWORD='123'

--差异还原
RESTORE HEADERONLY FROM DISK='d:\Backup\pubs_Full_20070908.bak' WITH PASSWORD='123'

MSSQL常用备份还原脚本如上。