Windows Server 2008 R2 Thread, Move database to 2nd hard drive? in Technical; Hi
Dont know a great deal about sql.
Have a new server running server 2008 R2 with Microsoft sql 2008 ...
-
26th June 2012, 06:01 PM #1 Move database to 2nd hard drive?
Hi
Dont know a great deal about sql.
Have a new server running server 2008 R2 with Microsoft sql 2008 R2 installed.
The server has two hard drives which appear as C: and D: in Windows.
I want all the databases to be stored on D:, so they are away from the system OS + the D: drive is large in size which I think will be helpful as the databases grow.
So my question is. How do I configure sql so the databases are stored on the D: drive?
Thanks.
-
-
IDG Tech News
-
26th June 2012, 06:08 PM #2 Surely you can just dismount the database in SQL management studio, move the database folder to the D: and then remount the database when all has been moved across.
-
Thanks to timbo343 from:
ihaveaproblem (26th June 2012)
-
26th June 2012, 06:09 PM #3 
Originally Posted by
timbo343
Surely you can just dismount the database in SQL management studio, move the database folder to the D: and then remount the database when all has been moved across.
I dont know :P can I ?
Sorry, really not clued up on sql ! I'll have a look and see if I can do your suggestion.
EDIT
That worked fine timbo.
Thanks very much.
So easy when you know how
Last edited by ihaveaproblem; 26th June 2012 at 07:11 PM.
-
SHARE: 
Similar Threads
-
By ihaveaproblem in forum Hardware
Replies: 1
Last Post: 23rd January 2012, 08:19 AM
-
By farquea in forum Windows
Replies: 15
Last Post: 24th March 2011, 01:10 PM
-
By RobFrain in forum Windows
Replies: 19
Last Post: 2nd February 2010, 02:58 PM
-
Replies: 9
Last Post: 1st August 2006, 10:25 AM
-
By wesleyw in forum Learning Network Manager
Replies: 8
Last Post: 29th April 2006, 08:26 AM
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules