加密,壓縮 備份
USE master
GO
--備份
Backup DATABASE [TestDB]
To disk='D:\tmpDBBak\TestDB_MediaPass_COMPRESSION.bak'
WITH mediapassword='123456',COMPRESSION
GO
--还原
RESTORE DATABASE [TestDB_MediaPass_COMPRESSION]
FROM DISK='D:\tmpDBBak\TestDB_MediaPass_COMPRESSION.bak'
WITH MEDIAPASSWORD='123456',
move 'TestDB' to 'd:\TmpDB\TestDB_MediaPass_COMPRESSION.MDF',
move 'TestDB_Log' to 'd:\TmpDB\TestDB_MediaPass_COMPRESSION_log.LDF'