Database Reference
In-Depth Information
Let us evaluate the policy of Backup and Data File Location against the production instances.
This policy will perform the steps to:
F Check if the database and the backups are on separate backup devices. If they are
on the same backup device, and the device that contains the database fails, your
backups will be unavailable.
F Putting the data and backups on separate devices optimizes the I/O performance for
both the production use of the database and writing the backups, as shown in the
following screenshot. (This is one of the Best Practices of Maintenance policies from
Microsoft SQL Server 2008 R2 Best Practices Analyzer.)
 
Search WWH ::




Custom Search