backup-files-must-be-on-separate-devices-from-the-database-files.md

title	Backup Files Must Be on Separate Devices from the Database Files | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology
ms.topic	conceptual
helpviewer_keywords	Best Practices [Database Engine]
ms.assetid	7039bebb-1f25-4cf3-81f1-393dfb78da12
author	mashamsft
ms.author	mathoma
manager	craigg

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

Monitor and Enforce Best Practices by Using Policy-Based Management