Click or drag to resize

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

The topic describes the SA0086 analysis rule.

Message

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

Description

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 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.

Scope

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

Parameters

Rule has no parameters.

Remarks

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

Categories

Maintenance Rules

Additional Information
See Also

Other Resources