SA0086 : Avoid storing database backups on the same volume as the database’s data files
The topic describes the SA0086 analysis rule.
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.
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.
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