본문 바로가기

SQL Server/SQL Server Tip & Tech

12 Essential Steps After Installing SQL Server

http://www.sql-server-performance.com/articles/dba/post_installation_steps_p1.aspx
By : Sadequl Hussain
Jul 13, 2009

Step1: Install the Service Pack, Hotfixes and Cumulative Updates
Step 2: Configure SQL Services
Step 3: Configure Default Directories
Step 4: Configure Default Database Properties
Step 5: Configure tempdb Database
Step 6: Configure Server Properties and Features
Step 7: Configure Security
Step 8: Configure Error Logs
Step 9: Configure Database Mail
Step 10: Configure SQL Agent & Operator
Step 11: Configure Operating System
Step 12: Set up Maintenance Plans for System Databases