* 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
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 ........"
* 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.
* Under Installation Type select
Perform a new ............. option
* Select "I Accept........"
* Under Feature Selection
Database Engine Services
SQL Server Replication
Full Text Search....
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
* Under "Server Configuration" Click on button
Use Same account..........
Account Name: SQLDBEngine_user
FAQ:- Once I install SQL Server what are the logins created automatically?
* Login for service account
* Logins for added users in wizard
* Under Database Engine Configuration
* Click on "Add Current User"
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"
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.
* Binn - Consists of .exe and .dlls
* DATA - data and T.log files
* 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
FAQ: - When I am starting SQL Server it was not started successfully. What are the possible
scenarios? and how to troubleshoot it?
1. Logon Failure
* Problem with service account.
* Master files are moved or corrupted
* 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
* 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