您的位置: 首页  >  技术问答  >  在SQL Server 2012中受密码保护的SQL数据库备份

在SQL Server 2012中受密码保护的SQL数据库备份

分类: 技术问答 • 2022-07-22 21:49:35
问题描述：





我正在尝试在sql查询下执行以备份受密码保护的数据库。我在sql server 2012和sql server 2014中遇到问题。



Hi ,

I am trying to execute below sql queries for back the DB with password protected. I am getting below issue in sql server 2012 and sql server 2014.

BACKUP DATABASE TM001 TO DISK ='C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA' WITH PASSWORD='TEST'







BACKUP DATABASE TM001 TO DISK ='C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA' WITH MEDIAPASSWORD='TEST'





错误消息：



Error Msg : 

One or more of the options (mediapassword) are not supported for this statement. Review the documentation for supported options.





我已经google了，并且它说这个密码功能在sql server 2014和sql server 2012中已经停止。



如果有任何解决方案，请告诉我。



谢谢

M Dhanasekaran



我的尝试：





I have googled and its says this password feature has discontinued in sql server 2014 and sql server 2012.

Please let me know if there any solution.

Thanks
M Dhanasekaran

What I have tried:

One or more of the options (mediapassword) are not supported for this statement. Review the documentation for supported options.

答

作为 MSDN文档 [ ^ ]说：

As MSDN documentation[^] says:
Quote：

从SQL Server 2012开始， PASSWORD 和 MEDIAPASSWORD 选项已停止创建备份。您仍然可以恢复使用密码创建的备份。

Beginning with SQL Server 2012 the PASSWORD and MEDIAPASSWORD options are discontinued for creating backups. You can still restore backups created with passwords.


相关推荐