Wednesday, December 28, 2011

Installing and Configuring SQL Server 2008

System Requirements

* O/S                      : Windows2003 with sp2/ 2008 Server
* Memory               : 1GB
* CPU                    : >1GHz
* HDD                    : 2684MB
                               : 611MB for database server
* SQL Native Client
* .Net Framework 3.5 with sp1
* Windows Services
                :WMI (Windows Management Instrumentation)
                :RPC (Remote Procedural Call)
                :DTC (Distributed Transaction Coordinator)

Installing SQL Server
* SQL Server supports 2 types of installations
                1. Stand Alone Environment
                2. Cluster based ,,

1. Stand Alone installation
                * Creating service account
                                * R.C on My Computer --> Manage
                                * Local users and groups
                                * R.C on Users
                                * New User
                                                Name: SQLDBEngine_user
                                                pwd   hyd@123
                                   Confirm p  hyd@123
                                                Uncheck "User must change...."
                                                Click on Create button

                * Go to SQL Server dump or use DVD
                * Double click on Setup
                * Click on "Installation"
                * Click on "New Stand Alone ........"
                * OK
                * Under Setup Support Files --> Click Install

FAQ: - I am installing SQL Server in d: drive where 20GB free space is available. But in system drive (c:)       
            there is 100MB free space. Setup continue or fail?

                * Setup support files are installed in system drive where 118MB free space is required.
                 Setup fails.

                * Next
                * Under Installation Type select
                                Perform a new ............. option
                * Next
                * Select "I Accept........"
                * Next
                * Under Feature Selection
                                                Database Engine Services
                                                SQL Server Replication
                                                Full Text Search....
                * Next

                1. First time, select shared features also
                2. Install SQL Server always in NTFS not in FAT32. NTFS provides high security and high      
                * Select "Named Instance and enter: TEST
                                Instance Root Directory: d:\SQLSERVER
                * Next
                * Under "Server Configuration" Click on button
                                Use Same account..........
                                Account Name: SQLDBEngine_user
                                password      hyd@123
                * Next

 FAQ:- Once I install SQL Server what are the logins created automatically?
                SS 2005
                                * sa
                                * BUILTIN\Administrators

                SS 2008
                                * sa
                                * Login for service account
                                * Logins for added users in wizard

                * Under Database Engine Configuration
                                * Click on "Add Current User"
                * Next
                * Next
                * Next
                * Install
FAQ: - What are the differences in the installation of SS 2005 and SS 2008?
                * In SQL Server 2005 there is no
                                * Installation Center
                * Upgrading, edition change, rebuilding system databases etc we have to perform
                  by running setup from command prompt.
                                * There is no "ConfigurationFile.ini"
                * Next
                * Close

Post Installation Steps
1. Verifying installation
                * We can verify installation process using Summary.txt file, present in
                                C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log

2. Verifying instance folders

* For every instance the following folders are created in installation directory.
                                                * BACKUP
                                                * Binn     - Consists of .exe and .dlls
                                                * DATA   - data and T.log files
                                                * FTData
                                                * Install - consists of .sql files
                                                * Jobs     - jobs and maintenance plans
                                                * Log       - Error logs
                                                * repldata- Replication snapshot folder
                                                * Upgrade (2008)

 3. Configuring Error logs

* Error logs maintains events raised by SQL Server.
* Consists of both errors and information.
* Error logs are present in LOG folder of respective instance.
* SS supports
                1 Current Log
                6 Archieve logs by default.
* Current Log has all the events from server restart.
* Once the server is restarted all the events are flushed from   current log into Archieve1 and from  
   Archieve1 to Archieve2 etc. This process is called recycling error logs.
* We can recycle error logs explicitly without server restart   using

* We can read error logs using   sp_readerrorlog
* SS supports min 6 and max 99 error logs
* How to configure?

                * Go to SSMS --> Object Explorer --> Management
                * R.C on SQL Server Logs --> Configure
                                select checkbox "Limit no of ............"
                                Maximum logs..........: 20
                * OK

FAQ: - When I am starting SQL Server it was not started successfully. What are the possible   
            scenarios? and how to troubleshoot it?

Possible Scenarios
                1. Logon Failure
                                * Problem with service account.
                2. 17113
                                * Master files are moved or corrupted
                3. 3417
                                * After moving master files we have not granted read/write permissions on new folder
                                * Or any one startup parameter is missing.

How to troubleshoot?
                * Check windows event log
                                * start --> run --> eventvwr
                                * System
                                * In the right pane double click on Error
                * Using SQL Server error log
                                * Go to LOG folder of respective instance
                                * Open ERRORLOG in notepad and check for errors

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

SQL Server Error Logs

* Error Logs maintains events raised by SQL Server database engine or Agent. * Error Logs are main source for troubleshooting SQL Server...

SQL Server DBA Training

SQL Server DBA Training
SQL Server DBA