We help IT Professionals succeed at work.

Can I move my SQL 2005 data folder to a different drive?  Please recommend best practice.

1,588 Views
Last Modified: 2012-05-05
I recently installed SQL 2005 Workgroup Edition on my Windows 2003 Small Business Server.  I have 2 drives mirroring each other as drive C: with my OS also installed on it.  I also have a RAID 5 setup with 3 disks as my D: drive.  I installed SQL Server on my C drive and I'm looking for some advice.  Is there anyway I can move my data folder to the D drive for more redundancy?  I am also going to have alot of data in the database eventually so it may grow to large to fit on the C drive.  When I installed it, it upgraded some other SQL desktop instances so I'm kinda of afraid to uninstall.  

Please recommend what I should do in this situation. I should also store my log files on seperate disks than the data correct?
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I haven't done anything with it yet... could I just unistall and reinstall?
yes you can move to a different drive, use attach/detach

Commented:
I would detach/attach.

Or you can create the data folder on D: and then change the default location of the database when you create it to that folder.

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.