SA0086 : Avoid storing database backups on the same volume as the database’s data files

Avoid storing database backups on the same volume as the database’s data files

The rule checks for databases which have their backups stored on the same volume as their data files.

The database data files and backup files should be stored on different physical disks. If database files are stored on a single disk, in case of failure, neither the data files nor backup files will be available.

Note
Because the rule considers each logical volume as a physical volume, you should verify that each logical volume and mount point is located on a separate physical device.

Change the storage location of the the database backups to different volume as the one of the database files.

The rule has a ContextOnly scope and is applied only on current server and database schema.

Rule has no parameters.

The rule requires SQL Connection. If there is no connection provided, the rule will be skipped during analysis.

Maintenance Rules, Bugs

Backup Devices

Optimizing Backup and Restore Performance in SQL Server

Backup and Restore Strategies in SQL Server

Other Resources