Sunday, March 29, 2015

SQL Server Policy Management !

Below are some what we use:



Data file free space falls below 10% free space

Auto shrink is OFF

AUTO CLOSE is OFF

Backup Files Must Be on Separate Devices from the Database Files

Place Data and Log Files on Separate Drives

Check Integrity of Database with Suspect Pages


http://ift.tt/1a9ymui


No comments:

Post a Comment