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'
One or more of the options (mediapassword) are not supported for this statement. Review the documentation for supported options.
Quote:Beginning with SQL Server 2012 the PASSWORD and MEDIAPASSWORD options are discontinued for creating backups. You can still restore backups created with passwords.
PASSWORD
MEDIAPASSWORD
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)