installing system databases to a different folder during install

Question

Post reply

installing system databases to a different folder during install

learn_2005

Old Hand

Points: 324
More actions
March 28, 2008 at 4:54 pm

#120611

Hi,
Wanted to find out if there is a way during the install of sql server 2005 that i can install binaries on a attached drive (c:\ or d:\) and the system databases on a network drive.
if I cant do that, is there an easy way to move them to the network drive? Also is this a preferred way of installing sql server on a SAN?
Thanks for your replies.

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

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

Mohan Kumar SSCertifiable Points: 5365 More actions · Answer 1

You can do it after install. set trace flag 1807 in startup parameter that will allow you to use network drive.

-T1807 should be first parameter in Startup. Make sure you use ; to separate. Example:

-T1807;-d\\NAS001\SQLData\master.mdf;.........................................................

[font="Verdana"]--www.sqlvillage.com[/size][/font]

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 2

If you put your db-files on a remote disk, you are network dependant !!! (availability/latency).

Sans are directly connected to your server and are prefered.

Sans are used like any local drive, so you don't need the startup parameter.

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 3

Microsoft generally recommends that you use a Storage Area Network (SAN) or locally attached disk for the storage of your Microsoft SQL Server database files because this configuration optimizes SQL Server performance and reliability. By default, use of network database files (stored on a networked server or Network Attached Storage [NAS]) is not enabled for SQL Server. Refer this link, http://support.microsoft.com/kb/304261

[font="Verdana"]- Deepak[/font]

learn_2005 Old Hand Points: 324 More actions · Answer 4

Thanks for the replies.

I meant to say SAN instead of network. However, during the install process you never get an option to choose where to install the system databases which i thought was odd.

I have read several places where it is recommended that the system databases be installed on the SAN along with the user databases and others mentioning installing system databases with the binaries on the local drive and the user databases on the SAN.

what would be the best approach in your experience?

Thanks.

Johan Bijnens SSC Guru Points: 135368 More actions · Answer 5

you can provide the location at install time:

- using the install GUI (advanced button)

- or using an installation INI file.

there is a template.ini file on your install disk explaining all the options.

We use the ini-file sollution and keep the for means of recovery.