Post reply

Moving All SQL Server 2008 databases to a new San storage

  • March 15, 2013 at 4:27 am

    #275195

    Hi,

    Please we need you help and advice.

    We want to move all of the SQL server 2008 databases files to the new SAN (Active Passive Mode ). The SQL server machines will not be changed just we need to move the databases to the new installed SAN.

    1. What are the thing that we should consider?

    2. What steps need to follow in such case?

    Kind regards.

  • March 15, 2013 at 4:48 am

    #1597420

    So you have new SAN drives presented on your existing servers and you want to move files say from drive D to drive Z on the same server?

    If so, ALTER DATABASE dbname MODIFY FILE (logicalname, newfilelocation)

    ALTER DATABASE dbname SET OFFLINE WITH ROLLBACK IMMEDIATE

    Copy files from old location to new location

    ALTER DATABASE dbname SET ONLINE

  • March 15, 2013 at 5:40 am

    #1597445

    as anthony said but I would stop the apps first and take backups of all the databases.

    also, are you moving just user databases or system databases as well?

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

  • March 15, 2013 at 12:50 pm

    #1597629

    I'm want to move everything to the new san and remove the old san.

  • March 15, 2013 at 3:13 pm

    #1597714

    for system databases see here

    make sure you use the procedure for your version of SQL (I have presumed 2008)

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

Viewing 5 posts - 1 through 4 (of 4 total)

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