Hi Guys
I am using the following script to create encrypted database backups in SQL Server but I am getting an error message
"Msg 3032, Level 16, State 2, Line 1
One or more of the options (mediapassword) are not supported for this statement. Review the documentation for supported options."
Any help will be much appreciated.
I am using the following script to create encrypted database backups in SQL Server but I am getting an error message
"Msg 3032, Level 16, State 2, Line 1
One or more of the options (mediapassword) are not supported for this statement. Review the documentation for supported options."
Code:
BACKUP DATABASE AdventureWorks
TO DISK='C:\AdventureWorks.BAK'
WITH MEDIAPASSWORD='C0mplexP@ssW0rd'
GO
Any help will be much appreciated.