数据库备份和还原

 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/