9Pardhu Posted September 13, 2012 Report Posted September 13, 2012 How to know the current settings for a sql server for the following: Remove Builtin\Administrators from the SQL Server Logins Latest Service Pack for SQL Server Number of tempdb files Max Server Memory Value Rights to Perform Volume Maintenance Task for SQL Service Account Database Files Location Enable only required Network Protocols Review Members of System Adminstrators Role in SQL Server NETBIOS and Server Message Block should be Disabled Use Windows Only Authentication Mode Enable Lock Pages in Memory Rights Page file Size should be 1.5 to 2 times the actual RAM SQL Service Account SA account enabled
Hitman Posted September 13, 2012 Report Posted September 13, 2012 google cheste.. ee patiki... [img]http://i39.tinypic.com/23afb.gif[/img]
Recommended Posts