1.备份:
USE master
GOBackup 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'