I am currently using SQL SERVER 2012 Express Edition.
Now I want to take backup of my database With password protection.
So i tried
BACKUP DATABASE [NAME] TO DISK ='[PATH]' WITH PASSWORD='[PASSWORD]' 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.
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?
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.