SA0200 : Backup to tape syntax is deprecated

The topic describes the SA0200 analysis rule.

Message

Backup to tape syntax is deprecated

Description

The rule checks T-SQL code and reports usages of the deprecated BACKUP { DATABASE | LOG } TO TAPE syntax.

How to fix

It is recommended to use `BACKUP { DATABASE | LOG } TO DISK` syntax instead of the `BACKUP { DATABASE | LOG } TO TAPE` syntax.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters

Rule has no parameters.

Remarks

The rule does not need Analysis Context or SQL Connection.

Effort To Fix
20 minutes per issue.
Categories

Deprecated Features, Bugs

Additional Information
Example Test SQL
SQL
Copy
 1BACKUP DATABASE AdventureWorks2012  
 2TO TAPE = '.tape0', TAPE = '.tape1'  
 3MIRROR TO TAPE = '.tape2', TAPE = '.tape3'  
 4WITH  
 5   FORMAT,  
 6   MEDIANAME = 'AdventureWorksSet1'; 
 7
 8
 9BACKUP DATABASE AdventureWorks2012 TO TAPE  ='.tape0'  
10BACKUP LOG AdventureWorks2012 TO TAPE ='.tape0'
Analysis Results
  Message Line Column
1 SA0200 : Backup to tape syntax is deprecated. 2 3
2 SA0200 : Backup to tape syntax is deprecated. 2 23
3 SA0200 : Backup to tape syntax is deprecated. 9 38
4 SA0200 : Backup to tape syntax is deprecated. 10 33
See Also

Other Resources

Analysis Rules