Thursday, March 29, 2012

Error restoring MSDB database

I'm getting the following error while trying to restore the msdb database:
The backup of the system database on device
d:\mssql\backup\msdb_db_200510312200.BAK
cannot be restored because it was created by a different version of the
server (134218488) than this server (134218546).
Both servers are SQL2000 SE.
Ron
Ron wrote:
> I'm getting the following error while trying to restore the msdb
> database:
> The backup of the system database on device
> d:\mssql\backup\msdb_db_200510312200.BAK
> cannot be restored because it was created by a different version of
> the server (134218488) than this server (134218546).
> Both servers are SQL2000 SE.
> Ron
The backup is from a server with an older service pack than the one you
are restoring to. Make sure they are both the same service pack.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Can you tell from the version from the number - (134218488)?
"David Gugick" wrote:

> Ron wrote:
> The backup is from a server with an older service pack than the one you
> are restoring to. Make sure they are both the same service pack.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||Ron wrote:
> Can you tell from the version from the number - (134218488)?
>
I think that is SP3/SP3a, but read the following links for info on how
to get the version and a possible way to restore the msdb.
http://www.developmentnow.com/g/118_...the-server.htm
http://www.sqlservercentral.com/foru...ssageid=229354
David Gugick
Quest Software
www.imceda.com
www.quest.com

No comments:

Post a Comment