I am currently using SQL SERVER 2012 Express Edition.
But it showed error that SQL SERVER 2012 Does not support the "WITH PASSWORD".
Can any one please help me with the solution. I want to backup DB with password Protection.
asked Sep 21, 2015 at 02:15 PM in Default
With the 2012 (and higher) Express versions, I think that your options are limited to third party solutions such as Red Gate's SQL Backup - http://www.red-gate.com/products/dba/sql-backup/
TDE is an Enterprise version only solution and you can't natively encrypted backups until 2014, which also requires Standard or higher per the supported features list: https://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx
Not sure what else to suggest. Someone else might be able to offer up a suggestion. Is the purpose to secure the backup file itself or the contents within it?
answered Sep 21, 2015 at 06:50 PM
You can utilize something like 7zip or WinZip to put the backup file into a compressed file, then password protect the compressed file. I know 7zip supports passing the password through the command line if you need to automate the process, not sure on WinZip.
answered Sep 22, 2015 at 01:15 PM