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.
RonRon 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:
> > 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
>|||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_2003_11_0_0_464983/Restore-error--different-version-of-the-server.htm
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=229354
David Gugick
Quest Software
www.imceda.com
www.quest.comsql

No comments:

Post a Comment