+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1

    Join Date
    Jun 2010
    Location
    England
    Posts
    735
    Thank Post
    89
    Thanked 52 Times in 46 Posts
    Rep Power
    35

    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.

  2. #2
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,017
    Thank Post
    304
    Thanked 288 Times in 200 Posts
    Rep Power
    120
    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.

  3. Thanks to timbo343 from:

    ihaveaproblem (26th June 2012)

  4. #3

    Join Date
    Jun 2010
    Location
    England
    Posts
    735
    Thank Post
    89
    Thanked 52 Times in 46 Posts
    Rep Power
    35
    Quote Originally Posted by timbo343 View Post
    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:
+ Post New Thread

Similar Threads

  1. Best place to buy hard drives from at the moment?
    By ihaveaproblem in forum Hardware
    Replies: 1
    Last Post: 23rd January 2012, 08:19 AM
  2. Loading multiple images to one hard drive
    By farquea in forum Windows
    Replies: 15
    Last Post: 24th March 2011, 01:10 PM
  3. Software to view Hard Drive Space?
    By RobFrain in forum Windows
    Replies: 19
    Last Post: 2nd February 2010, 02:58 PM
  4. Replies: 9
    Last Post: 1st August 2006, 10:25 AM
  5. LNM failed to format hard drives
    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
  •