Post reply

moving database files to another disk

  • November 24, 2011 at 1:21 am

    #247391

    Hi All,

    Please give me some advice on how to move the database files to another disk. The instance have only one DB and the Db files are on a SAN disk and this disk is old and we have now a new SAN and I want to move the DB files to this new one. The DB is simple recovery. Please give me some directions as I never done this before. Thanks in advance

  • November 24, 2011 at 2:26 am

    #1412592

    If you can afford some downtime, the simplest way to do this would be a backup/restore with move to the new storage. Detach/attach would do the trick as well.

    Another option could be moving the files using this method.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • November 25, 2011 at 8:54 am

    #1413008

    Thank you for the advice, how about the system databases,

    can they be moved similarly - master and Model

    Does the tempdb needs to be moved as well

  • November 25, 2011 at 10:15 am

    #1413031

    This is the process for moving system databases at SQL2005

    tempdb is the easiest and safest to move, personally I avoid moving the other system databases unless I really have to.

    ---------------------------------------------------------------------

  • November 25, 2011 at 12:17 pm

    #1413058

    Thanks again, but I have to move them as they are on the

    Same disk as well, what are the risks when moving the system

    Db's.

  • November 25, 2011 at 12:33 pm

    #1413061

    awp (11/25/2011)

    Thanks again, but I have to move them as they are on the

    Same disk as well, what are the risks when moving the system

    Db's.

    If it goes wrong it can be complicated getting SQL working again, an error in moving these databases will lead to SQL not starting.

    Make sure you follow the instructions carefully and you have this planned out. Avoid typing mistakes when specifying the new locations. Try and test the process somewhere if you can.

    Having said that I have done this a number of times and it does not actually take that long. In SQL2005 keep the master database and resource database together in the same location and don't be tempted to split the data and log files up for the system databases.

    ---------------------------------------------------------------------

  • November 26, 2011 at 3:11 am

    #1413095

    Thanks a lot for all your advice it made me a lot wiser, if any more queries, will come back to u,

    Cheers

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply