Jump to content

Sql Server Help Need To Find These


Recommended Posts

Posted

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

Posted

google cheste.. ee patiki... [img]http://i39.tinypic.com/23afb.gif[/img]

×
×
  • Create New...