sql 2012的数据库备份 [英] Database Backup for sql 2012

问题描述

如何创建< pre lang =c＃>< / pre> sql server 2012中的数据库备份，传递

How to create <pre lang="c#"></pre>Database backup in sql server 2012 with pass

推荐答案

我不知道非常明白为什么你发布了数据库的创建脚本，但是如果要进行备份，请按照中的说明进行操作。创建完整数据库备份（SQL Server） [ ^ ]

I don't quite understand why you posted the create scripts for the database but if you want to take a backup, follow the instructions in Create a Full Database Backup (SQL Server)[^]

Quote：

从SQL Server 2012开始，PASSWORD和MEDIAPASSWORD选项已停止创建备份。

Beginning with SQL Server 2012 the PASSWORD and MEDIAPASSWORD options are discontinued for creating backups.

如何在SQL 2012中创建完整数据库备份 [ ^ ]

How to create full database backup in SQL 2012[^]

Quot e：

WITH PASSWORD功能并没有真正加密您的备份。它只是让某人在不允许的时候意外恢复备份并且密码选项很弱而且很容易被破坏。保护数据的唯一真正方法是使用第三方备份工具创建加密备份或备份到加密媒体。对于敏感数据，您应该备份到加密磁带，因为磁带容易丢失并丢失。



否则您可以通过加密数据库来加密源数据。

The WITH PASSWORD feature didn't really encrypt your backup. It just made it difficult for someone to accidentally restore the backup when they were not allowed to and the password option was weak and could be broken easily. The only true way to protect the data is to use a 3rd party backup tool that creates an encrypted backup or to backup to an encrypted media. For sensitive data you should be backing up to encrypted tape anyway as tapes easily get lost and go missing.

Otherwise you can encrypt the data at the source by encrypting the database.

Sean Massey在 SQL论坛 [ ^ ]

Sean Massey on the SQL Forum[^]

试试


https://technet.microsoft.com/en-us/library/ms191304(v=sql.105).aspx [ ^ ]

和

https://msdn.microsoft.com/en-IN/library/ms187510.aspx [ ^ ]

try

https://technet.microsoft.com/en-us/library/ms191304(v=sql.105).aspx[^]
and
https://msdn.microsoft.com/en-IN/library/ms187510.aspx[^]

这篇关于sql 2012的数据库备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！