msdb restore

I have a client who is trying to restore an old backup of
the msdb database. Of course, their new build of SQL is
different, so they can't do the restore. We get an error
similar to:
"Server: Msg 3168, Level 16, State 1, Line 1
The backup of the system database on device
d:\temp\master.bak cannot be restored because it was
created by a different version of the server (134217904)
than this server (134217920).
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally. "
what I need to know is how to interpret the version number
in the error message - i.e. "134217904" so I can figure
out what version they need to have running in order to
restore. Anyone have any ideas?
Thanks!Take a look at Q264474. That will help you :-)
/Peter
"Lia" <lkeston@.patriotsoftware.biz> wrote in message
news:4cdc01c3d5fb$f1edd8b0$7d02280a@.phx.gbl...
> I have a client who is trying to restore an old backup of
> the msdb database. Of course, their new build of SQL is
> different, so they can't do the restore. We get an error
> similar to:
> "Server: Msg 3168, Level 16, State 1, Line 1
> The backup of the system database on device
> d:\temp\master.bak cannot be restored because it was
> created by a different version of the server (134217904)
> than this server (134217920).
> Server: Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally. "
> what I need to know is how to interpret the version number
> in the error message - i.e. "134217904" so I can figure
> out what version they need to have running in order to
> restore. Anyone have any ideas?
> Thanks!
>|||The following command should tell you what build of SQL Server the backup
was taken from:
RESTORE HEADERONLY
FROM DISK = 'd:\temp\master.bak '
You can look at http://support.microsoft.com/?id=264474 for further
information.
Rand
This posting is provided "as is" with no warranties and confers no rights.