---建立备份文件
backup database northwind to disk='c:/a.bak'
backup database northwind to disk='c:/b.bak' WITH DIFFERENTIAL
---测试如下(还原完敕备份)
RESTORE DATABASE northwind
FROM disk='c:/a.bak'
WITH NORECOVERY,
MOVE 'northwind' TO 'D:/Microsoft SQL Server/MSSQL/Data/northwnd.mdf', ---主数据文件名
MOVE 'northwind_log' TO 'D:/Microsoft SQL Server/MSSQL/Data/northwnd_log.ldf', --日志文件名
file=1---这里输入完全备份的文件号
--还原差异备份
RESTORE DATABASE northwind
FROM disk='c:/b.bak'
--MOVE 'MyNwind' TO 'c:/Program Files/Microsoft SQL Server/MSSQL/Data/NewNwind.mdf', ---主数据文件名
--MOVE 'MyNwindLog1' TO 'c:/Program Files/Microsoft SQL Server/MSSQL/Data/NewNwind.ldf' --日志文件名
with file=1---这里输入差异备份的文件号