--备份(这两条语句一起才算是完整的备份,第一条是备份数据库,第二条是备份日志,在实际使用中推荐使用这种方式)
Backup Database PowerCheck To disk='D:/back/20070908.bak'
With Password = '123456' ;--这是密码
Backup log PowerCheck To disk='D:/back/20070908_log.bak'
With Password = '123456';--这是密码
--恢复(只需要用一条语句就搞定)
Restore Database PowerCheck
From disk='D:/back/20070908.bak'
With Password = '123456';
原文出处:http://hi.baidu.com/huqing7002/blog/item/de38d7d3b4857cd7a8ec9af0.html