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 |
|
danielc
Starting Member
49 Posts |
 Posted - 2007-03-14 : 16:06:37
|
| Hello all,I am installing SQL Server 2005 on our server and have researched with no success on how to redirect the Data Files and Log files to a different drive, e.g. D: drive. In SQL Server 2000 you specified where you wanted to place the LOG files and Data files upon Setup.I have looked everywhere in SQL Server 2005 install and cannot find where I can tell it to place the Data and Log files. Please point me in the right direction.Your help is greatly appreciated,Dan |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-03-14 : 16:50:22
|
| When you get to Feature Selection Screen (advanced options), Expand the database services item, and select the datafiles item. Click browse, and place them wherever. |
 |
|
|
danielc
Starting Member
49 Posts |
Posted - 2007-03-14 : 16:58:40
|
| Ah! Thank you very much... Again SQL Team has come to my rescue...Dan |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-14 : 22:21:09
|
| Note that it will append subfolders to your path for:...\MSSQL.n\MSSQL\xxxSo probably best to just give it a root path!Kristen |
|
|
|
|
|
|
Log and Data files...