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 |
|
airski
Starting Member
2 Posts |
 Posted - 2006-08-14 : 14:17:49
|
| I'm getting ready to install SQL Server 2005 Enterprise for the first time and I have a question about the directory location of the log files and the data files. I have 3 RAID arrays on my server, 1 for the OS, 1 for SQL Logs, and 1 for SQL Data.Here's my issue. I want to install the logs on the Log array and the SQL data on the SQL data array, however, during the installation I can't find anything that allows me to select certain directories!Am I missing something somewhere?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-14 : 14:22:24
|
| The installation doesn't allow you to select the option. You just put them on the different drives during the creation of the database and/or restoring of the database. The system databases will get created on the drive and directory that is selected in the installation. To move the LDF to a different location, you can use this method:http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&Product=sql2kTara Kizer |
 |
|
|
airski
Starting Member
2 Posts |
Posted - 2006-08-14 : 15:38:27
|
| So when you add a new DB it asks for the path then? Does it ask for the log path then as well? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-14 : 15:45:55
|
quote:
Originally posted by airski
So when you add a new DB it asks for the path then?
Yes.quote:
Originally posted by airski
Does it ask for the log path then as well?
Yes. Tara Kizer |
|
|
|
|
|
|
Install Logs and Data on separate arrays