Tuesday, March 10, 2015

Steps to install sql server. questions to ask customer :-


Steps to install sql server. questions to ask customer :-

1. version to install? 2000,2005,2008,r2,2012
2. edition to install ? ee ,std, wg,datacenter...
3. default or names instance ?
4. named instance--> name?
5. installtion path in which drive? data and log files drive ? installtion: E, data file: D, log files: L
6. services to instll? database , analysis,intergration, reporting ?
BI tools: AS,RS, IS
7. service account?
8. SA pwd?
9. any collation setting ?
10. in 2005 for RS installtion the IIS must be installed. for sql 2008 its not req.
11. in 2005 installtion --> advanced--> location of database u have to chnage
12. installtion errors--> mycomputer-->manage--> application error log
summary text file location : C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log.

Diff between installtion for 2005,2008
==========================
1. IIS is mandatory to install SSRS in 2005 , but 2005 wont require..
2. database file location.( in 2008, data , log, backup, tempdb path are diff)

No comments:

Post a Comment

COMMON SQL SERVER BACKUP FAILURE ERRORS AND ISSUES

  One of the most common task for a DBA’s are to perform installation of new SQL Server versions and installing patches. Most often or not e...