Share via


Backup Files Must Be on Separate Devices from the Database Files

This rule checks whether database files are on devices separate from the backup files. If database files and backup files are on the same device and the device fails, the database and backups will be unavailable. Also, putting the database and backup files on the separate devices optimizes the I/O performance for both the production use of the database and the writing of backups.

Best Practices Recommendations

We strongly recommend that you put the database and backups on separate backup devices.

Note

This policy cannot detect separate physical devices through mount points.

For More Information

Backup Devices (SQL Server)

Back Up and Restore of SQL Server Databases

See Also

Concepts

Monitor and Enforce Best Practices by Using Policy-Based Management