sql installation on other than c :\Drive

Question

sql installation on other than c :\Drive

sivark1

SSCrazy

Points: 2654
More actions
March 15, 2010 at 4:49 am

#139493

Hi
while installing sql software (2000\2005)
can i install all the services like (Dtabase engine ssis,ssrs etc...) in D\E drive or
what services need to install on c:\drive(default)
in case c: drive or O/S corrrupts need to be recover the all sql files(mdf& Ldf) ...
this task need to be done in in production boxes
please provide suggessions
Thanks in advance

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

Best practice suggests you install your engine, agent etc on a different drive, your MDF's on its own drive and your LDF's on its own drive.

never install your SQL Engine and prog files on the sam drive as the mdf or ldf's.

You can install your SQL Engine on C, but choose to store the master, msdb, model and temp mdf's and ldf's on D and E seperately, they dont need to be on the same disk.

Hope this answer's your question?

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 2

Sure, you should never mix the OS and the database on the same spindle. And all databases should be on a separate spindle. If you are developing at home, then it will not matter too much, but I would still separate everything. You should not have one single large partition on a computer any way.

I have mine all on separate drives. My bin directory is on Drive M, my system databases are on Drive F and my user databases are on drive L

Remember drive letters are just that, letters, an easy way to identify the drive's actual address. All of my boxes at home are set the same, so that I can easily backup and restore. I set the drives of my company the same way, not the same letters, but the same fashion. That way when I need to restore, I can quickly perform the restore, because the drive letters are all the same on all boxes.

Andrew SQLDBA

Lowell SSC Guru Points: 323518 More actions · Answer 3

I'd seen this question here before, and i believe the SQL Engine install can only occur on the %SystemDrive% drive; in most cases that is the C:\ drive;

as already identified, the databases can be installed on other drives and locations.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

AndrewSQLDBA SSC-Insane Points: 21827 More actions · Answer 4

Mine are on different drives. I actually do not have a Drive C. Well I do, but it is only 7Mb. I had to have that for the System Drive Boot Files for 2003 Server. But none of the SQL files are on the Boot Drive.

Boot Drive - Location of the Operating System.

System Drive - Location of the OS Boot files, NTLDR, Boot.ini, etc...

As long as you do not have something like Express edition that integrates into the OS, you can install SQL Server on any drive that you have access too.

Andrew SQLDBA