Solved

MS SQL Express How to make the Database on separate disk or separate partition

Posted on 2010-08-19
2
381 Views
Last Modified: 2012-05-10
Hello Everyone;

I'm not really good at MS SQL, but I would like to install it on the C Drive and have all the database saved on the D Drive.

is there any way we can do it ? I already have installed MS SQL on the C:\ dive so what i'm most interested in, is how to make the DB be saved completely on another disk partition (in our case D:\).

Thanks  
0
Comment
Question by:atigris
2 Comments
 
LVL 16

Expert Comment

by:carsRST
Comment Utility
When you create a database you should be able to specify where to store the database files.

You can also change the default location:

http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/c16a591f-86cc-4ce2-94ef-c8ad34054de8
0
 
LVL 2

Accepted Solution

by:
atigris earned 0 total points
Comment Utility
This is how it is done;

1. you can change  SQL Server default DB and LOG location (this option is available on SQL Express 2005,2008)

 SQL Server Management Studio - right click on the Server - property - Database settings - Database default location

specify the new location of the DB and Log

2. You can do it at SQL DB level (This option is not available on SQL Express edition)  

http://www.psoft.net/HSdocumentation/sysadmin/mssqlchangehome.html

If you still want to do it on SQL Express edition (follow method 1# )

   1.  Create new MS SQL data location (E:\MSSQL\data\)
   2. Stop MS SQL server
   3. Move all databases to a new location (move *.mdf and *.ldf files)
   4. Create junction link between old and new MS SQL data folders. This can be done with Sysinternals Junction or any other utility of this kind
   5. Start MS SQL server

That is all there is to it.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now