Post reply

Moving database files to another drive

  • April 8, 2021 at 2:33 pm

    #3866874

    Hi all

     

    For background, we ave two servers (DEV and PROD) and they are set up slightly differently.

    On DEV, the mdf files are stored on the E: drive, on PROD the mdf files are stored on the D: drive.

     

    What I'd like to do is change the drive on the DEV server to be D: to match the PROD server (we have some code that references the drives by letter that I have to remember to change when I push the code from DEV to PROD.

     

    I can easily move the user database files from one drive to another (I've got code for that).

    I'd like to move the system databases as well but I don't want to crash everything.

     

    Is the routine the same for moving the mdf's for the system databases the same as for user databases?

    I've attached my code for moving the user databases for reference.  It generates a script (with comments) that you run through in sections as you move the files around (any improvements on this would be appreciated) as we occassionally get databases created on the wrong drive.

     

    TIA

     

    Richard

    Attachments:
    You must be logged in to view attached files.

  • April 8, 2021 at 3:01 pm

    #3866884

    msdb, model, & tempdb can be moved through relatively normal means (though you have to restart SQL Server afterwards).

    master requires modifying startup parameters and the registry... and maybe a prayer 🙂

    See

     

  • April 22, 2021 at 8:07 am

    #3874239

    Hi all

    Firsty,apologies for the late reply.

     

    I think I'm going to leave things alone (just in case).

    I've grabbed a workaround for the issue of different drive letters so I think I'm going to leave it alone.

     

    Thanks

     

    Richard

Viewing 3 posts - 1 through 2 (of 2 total)

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