--清除环境
exec master..xp_cmdshell 'del c:\test.bak'
if exists(select * from master..sysdatabases where name='test')
drop database test
go
--创建数据库
create database test
go
--打开创建的数据
use test
go
--创建测试表
create table t(a int)
--切换回master数据库
use master
go
--插入数据1
insert into test..t select 1
go
--然后进行一次完整备份
backup database test to disk='c:\test.bak'
go
--插入数据2
insert into test..t select 2
go
--再进行一次完整备份
backup database test to disk='c:\test.bak'
go
--插入3,4
insert into test..t select 3
insert into test..t select 4
go
--差异备份:
backup database test to disk='c:\test.bak' with differential
--删除数据库
drop database test
--还原数据库和差异数据库备份
restore database test from disk='c:\test.bak' with file=2,norecovery
restore database test from disk='c:\test.bak' with file=3,recovery