Post reply

Restore Master database next to other Master database

  • September 7, 2009 at 5:41 am

    #385318

    I have an old backup of a SQL 2000 master database where I have to retrieve some information from.

    The old server is no longer available so I want to restore the old master database next to another and rename the old one.

    Al works fine untill I get the following error: "There is already an object named sysnjobs in the database".

    How can I overcome this?

  • September 7, 2009 at 6:58 am

    #1050094

    Not sure how to get around that on the restore. I do have a different thought. You could build a little Virtual Machine if you have the software and build a SQL 2000/Win 2000 box with just enough juice to install that master.. It shouldn't take more than 2 hours to setup, so if there is another way it might be better.

    CEWII

  • September 7, 2009 at 4:16 pm

    #1050249

    Since system databases cannot be moved I don't see this happening.

    When going for solution suggested in previous post please be aware a system database can only be restored in a SQL Server of the same build as the one where the system database belonged e.g. a SS2K Master database cannot be restored on top of a SS2K5 server.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

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

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