PASSWORD/MEDIAPASSWORD options in BACKUP/RESTORE statement are deprecated

Since SQL Server 2012, the PASSWORD and MEDIAPASSWORD options are discontinued for creating backups.

It is important to password-protect backups. However, the protection that this option afforded was not up to current standards. Properly set-up ACLs on the directory provides stronger protection, as does a third-party backup solution.

Available in

 SQL Code Guard

Didn't find what you were looking for?