Installation Best Practices

Last Post 11 Apr 2011 10:23 AM by gunneyk. 7 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
PaulMcKibben
New Member
New Member

--
11 Apr 2011 06:59 AM
Can someone point me to a website that definitely states the best practices on installing SQL Server and its components?  I am looking for the drive best practices.  For example, what should go on the C drive and where the application should be placed. 

The team that I work with has always install SQL Server and its components on the C drive.  That I believe is not best practice, but I need something definite. 

Thank you.
skhanal
New Member
New Member

--
11 Apr 2011 07:06 AM

Installing anything other than OS in C: drive is asking for trouble later. But even if you install SQL Server in other drives, you will still end up with certain components in C:\Program Files folder.

The rule of thumb is to separate these

1. SQL Server binary

2. Database Data Files

3. Database Log Files

4. Tempdb files

5. Backup Files

Now depending on your server, do you have that many drives?. What if one runs out of space, can you expand it easily. Also with SAN in picture all the drives may be pointing to one giant higly striped pool of disks, in that case all these best practices may be meaning less, unless you have separate large pool of disks for each of these and in many environment that is highly unlikely.

PaulMcKibben
New Member
New Member

--
11 Apr 2011 07:32 AM
Thank you for your response.

We have, to date, set up all of our SQL servers has you mentioned except that we install SQL Server on the C drive, and the backup file location is the same as the Database Data files.

I am looking for a MS website that lays the best practices out regarding the drives.

I am the new DBA on the team and am fighting some "this is the way that we have done things in the past". That is the reason I asked for a web site.

river1
New Member
New Member

--
11 Apr 2011 07:46 AM
"and the backup file location is the same as the Database Data files. " Does this mean that you store your backups in the same place where you have the data files of your databases?

PaulMcKibben
New Member
New Member

--
11 Apr 2011 08:21 AM
On the same drive but a different folder.

river1
New Member
New Member

--
11 Apr 2011 08:22 AM
what happens if drive fails?
PaulMcKibben
New Member
New Member

--
11 Apr 2011 08:43 AM
I appreciate your concern and responses.

My initial question is/was specifically about MS best practices on where to install the SQL server application and if anyone knew of a website that specifically addressed this.

gunneyk
New Member
New Member

--
11 Apr 2011 10:23 AM
I am not sure if you will find such a paper as such because there are many factors to consider and thus it will depend on some of those. Havign said that here are some Storage and I/O white papers and Best Practices that might help. And the first one is from 2000 but does have some guidelines on placement.

http://technet.microsoft.com/en-us/...66508.aspx

http://sqlcat.com/whitepapers/archi...tions.aspx
http://sqlcat.com/whitepapers/archi...tices.aspx
http://technet.microsoft.com/en-us/...66414.aspx
http://technet.microsoft.com/en-us/...66534.aspx

http://sqlcat.com/whitepapers/archi...-2008.aspx
You are not authorized to post a reply.

Acceptable Use Policy