DF050: In the BACKUP/RESTORE statement, deprecated options are used.

Last modified: May 28, 2025

The topic describes the DF050 T-SQL code analysis rule.

Message

In the BACKUP/RESTORE statement, deprecated options are used.

It is not recommended to create and restore backups with the depreciated TAPE, PASSWORD, and MEDIAPASSWORD options.

BACKUP DATABASE Northwind
TO DISK='C:\Northwind.BAK'
WITH MEDIAPASSWORD='mypassword'
GO
 
RESTORE VERIFYONLY
FROM TAPE = 'SampleTape'
GO

BACKUP DATABASE Northwind
TO DISK='C:\Northwind.BAK'
 
GO
 
RESTORE VERIFYONLY
FROM DISK = 'C:\Northwind.BAK'
GO

Was this page helpful?

Yes

Take a quick tour to learn all about the key benefits delivered by SQL Complete.

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

If you consider employing this tool for your business, request a demo to see it in action.