/*创建一个数据库wcc*/
create database wcc
go
/*将数据库wcc备份到c盘*/
backup database wcc
from disk = 'c:\wcc.bak'
backup database wcc
to disk = 'c:\wcc_diff.bak'
with differential
go
select * into wcc.dbo.xxx
from sys.objects
delete top (1) from wcc.dbo.xxx
go
restore database wcc
from disk = 'c:\wcc.bak'
with replace,norecovery
/*从c盘中将wcc数据库还原*/
restore database wcc
from disk = 'c:\wcc_diff.bak'
with recovery
create database wcc
go
/*将数据库wcc备份到c盘*/
backup database wcc
from disk = 'c:\wcc.bak'
backup database wcc
to disk = 'c:\wcc_diff.bak'
with differential
go
select * into wcc.dbo.xxx
from sys.objects
delete top (1) from wcc.dbo.xxx
go
restore database wcc
from disk = 'c:\wcc.bak'
with replace,norecovery
/*从c盘中将wcc数据库还原*/
restore database wcc
from disk = 'c:\wcc_diff.bak'
with recovery