Team ,

I know answer to my question is "It Depends"  . But still , Just wanted  to check what would be your recommended or most frequently implemented  SQL Server Policies  within your Server Instance(s) .

Thanks in advance for your

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

https://msdn.microsoft.com/en-us/library/cc645723.aspx

• Proposed as answer by Eric__ZhangMicrosoft contingent staff, Moderator 1 hour 25 minutes ago

Thank You  , Any one would like to add on to this List ?

Team ,

I know answer to my question is "It Depends"  . But still , Just wanted  to check what would be your recommended or most frequently implemented  SQL Server Policies  within your Server Instance(s) .

The answer still remains it depends on your environment. What are you asking is not policy, its best practice. Policy is different from best practice.

Policies are mosty pushed from Domain controller. Yes you have policy based management in SQL Server but your question is too wide. Can you exactly tell what you are looking for ?