SQL Server Installation Notes

Check lists will vary for everyone but there are a few configurations that will be
common to all lists. For example:
• Data and Log File Standard Location
• Data: E:\DataFiles
• Logs: F:\TLogs
• Service Account: (Created service account and grant local privileges)
• TempDB Location
• T:\TempDB
• Special Permissions (memory – AWE)
• Lock Pages in Memory
• Boot.ini
• Configure for /PAE switch if 32 bit Windows 2003 and SQL
Server Standard or Enterprise
• Additional vendor-supplied (Non SQL) applications
• Defragmentation
• SQL Backup Compression