Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2005-08-18 : 08:50:48
|
| I am doing a new - named instance - install on a new Server and I'm having a hard time getting my brain around how to set up the data and log file locations how I want them. I know how to change the default locations for data and log files once the Instance is up and running, but when I do the install, it puts the mdf and ldf files for all of the System Databases in a folder called mssql$instancename on the drive I am specifying. What I want to end up with is a folder for each of the database (ie, master, model, msdb, tempdb, userdb1, userdb2, etc...) on two different drives and house the data and log files seperately. Can I do this at install time or do I need to move the system database files around after install. If so, can someone outline the steps for doing this???? |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-18 : 09:14:59
|
| Best done at Install time. I think there's an option to do this in the GUI installer, isn't there (I'm pretty sure that's where I do it).Alternatively you could use an Unattended Setup FileKristen |
 |
|
|
bmanoj
Starting Member
13 Posts |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2005-08-18 : 09:22:12
|
| yes, at install time with the GUI install, you can specify the default location for Program Files and for Data Files.. that's a start. I'll use the MS article and move my mdf and ldf files around after install.. Thank you so much! |
|
|
|
|
|
|
|
|
moving System DB mdf and ldf files