I would like to setup all the DTS packages from a production server to my
workstation for testing and development. My workstation recently became a
client of a Small Business Server 2003 Domain. Prior to this change, I was
able to force a database restore of the MSDB database onto the Workstation
SQL Server. Since this change, I had to re-install all Office Pro 2003 apps
and the SQL Server software on this machine. The current environment is as
follows:

Production: MSSQL 2000 Enterprise Edition 8.00.760 (Intel x86) on Windows
NT 5.0 (Build 2195 SP4)

Workstation: MSSQL 2000 Developer Edition 8.00.194 (Intel x86) on Windows
NT 5.1 (Build 2600 SP2).

When I attempt to restore the MSDB database from production on the
Workstation, I get the following error: "The backup of the system database
on device ... cannot be restored because it was created by a different
version of the server (134218488) than this server (134217922). RESTORE
DATABASE is terminating abnormally."

Attempts to install a different version of MSSQL on the Workstation has
failed with a message indicating that this version of the software is not
intended to be installed on this hardware, or something similar.

I have access to an old copy of MSSQL 2000 Enterprise from an MSDN
subscription that I have not tried yet. Any suggestions would be appreciated.
--
Thank you.

The message means the 2 versions of SQL Server are running different Service
Packs.

8.000.760 is SP3a

8.00.194 is no service pack

If you install SP3a onto your Workstation you will be able to restore msdb

--
HTH. Ryan


"Warner" <ITLifecycler> wrote