Post reply

problem restoring MSDB

  • January 18, 2010 at 8:57 am

    #209237

    i had a sql server at a branch office running windows 2000/SQL 2000. hardware error and had to reinstall windows. i installed it as Windows 2003/SQL 2005. mounted all the databases but can't restore msdb. getting error code 5 when running it from Netbackup.

    is it possible to restore a SQL 2000 msdb backup on to a sql 2005 server? i named the server with the same name as it previously had. Not a big deal if i can't restore it. my plan b was to set up a vmware image, restore it, upgrade to sql 2005 and then copy the files over

  • January 18, 2010 at 9:11 am

    #1104989

    SQL Noob (1/18/2010)

    is it possible to restore a SQL 2000 msdb backup on to a sql 2005 server?

    I wouldn't recommend it. Not for any of the system databases.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 18, 2010 at 9:12 am

    #1104992

    I wouldn't even try it.

    I'd assume sql server to assume that the system DBs on a sql 2005 instance to be at the 90 level and nothing else.

    That's also most likely why the restore fails.

  • January 18, 2010 at 9:21 am

    #1105001

    thx

    I guess it's vmware to the rescue then

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

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