SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Log and Data files...		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

danielc
Starting Member

48 Posts
Posted - 03/14/2007 :  16:06:37  Show Profile  Reply with Quote
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 - 03/14/2007 :  16:50:22  Show Profile  Reply with Quote
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.
Go to Top of Page

danielc
Starting Member

48 Posts
Posted - 03/14/2007 :  16:58:40  Show Profile  Reply with Quote
Ah! Thank you very much... Again SQL Team has come to my rescue...

Dan
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 03/14/2007 :  22:21:09  Show Profile  Reply with Quote
Note that it will append subfolders to your path for:

...\MSSQL.n\MSSQL\xxx

So probably best to just give it a root path!

Kristen
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000