SA0200 : Backup to tape syntax is deprecated |
![]() |
The topic describes the SA0200 analysis rule.

Backup to tape syntax is deprecated

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

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

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

Rule has no parameters.

The rule does not need Analysis Context or SQL Connection.


Deprecated Features, Bugs


SQL
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' |

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 |
