Post reply

Moving master db onto a new drive

  • July 7, 2005 at 6:47 am

    #186571

    Hi,

    I have a client who is upgrading their production server and needs to run SQL on a different drive (C:\ drive on the new server, SQL is currently running on the E:\ drive on the old server). They have installed SQL onto the new server and contacted us when they ran into problems. Basically when we restore the master database onto the new server, SQL will not re-start. I'm restoreing through EM in single user mode, and specifying the new location of the data and log files on the options tab.

    We can get all the other databases restored and ideally I want to avoid having to set up all the logins on the new server.

    Has anyone else tried to restore a master backup to a new location?

    cheers

    Dave

  • July 7, 2005 at 12:22 pm

    #572025

    Just look at here

     

    http://www.databasejournal.com/features/mssql/article.php/3379901

     

    Thanks

    Amish Shah

  • July 8, 2005 at 12:19 am

    #572178

    Hiyas

     

    This is my favourite article from MS

    http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

    You can modify the parameters in the registry, before starting up the SQL Server service. This can be used if you manually copy the master files from one location to another.

    HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters

    This is not really recommended.

     

    Regards

    hot2use


    __________________________________
    Searching the KB articles is like
    picking your nose. You never know
    what you'll find.

  • July 8, 2005 at 3:43 am

    #572228

    Amish / hot2use,

    Thanks for your suggestions.

    cheers

    Dave

     

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

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