use stusystem3
backup database stusystem3
to back111
with init,
name='back111'
use stusystem3
BACKUP DATABASE stusystem3
TO back111
WITH NOINIT,
differential,
name='back111_chayibeifen'
backup log stusystem3
to back111
with noinit,
name='back111_rizhibeifen',
description = 'this is transaction backup of...'
drop database stusystem3
restore database stusystem3
from back111
with file=1,norecovery
restore database stusystem3
from back111
with file=2,norecovery
restore log stusystem3
from back111
with file=3,recovery
我的博客园地址:一直更新acm。
http://www.cnblogs.com/TWS-YIFEI/