带密码数据库备份和恢复语句

1.备份：

USE master

 GO
 Backup DATABASE TEST1
 To disk='D:\201504291415.bak' WITH mediapassword='1234567890' ,PASSWORD='1234567890'
 GO
2：恢复：

 RESTORE DATABASE TEST1
   FROM DISK = 'D:\201504291415.bak'
   WITH RECOVERY,
   MOVE 'TEST1' TO 'D:\HTML\sss.mdf',
   MOVE 'TEST1_Log' TO 'D:\HTML\sss.ldf',
   password='1234567890',MEDIAPASSWORD='1234567890'