备份:
BACKUP DATABASE IWE_Build TO DISK = N'D:\DBBackup\IWE_Build2.bak' WITH INIT
GO
还原:
--显示备份集内容,有几个文件
RESTORE FILELISTONLY FROM disk='备份文件路径'
--还原数据库
restore database test1024 from disk = '备份文件路径'
with move '文件名1' to '新路径',
move '文件名2' to '新路径'
,RECOVERY
转载于:https://blog.51cto.com/zahuopu/1174804