restore msdb - MSDE 2000

hi. i'm trying to restore msdb (dmp)... the dmp was taken from MS Desktop Engine 2000 and i'm trying to restore it to ms sql server 2000. is this possible? if not, how can i restore msdb to MSDE 2000? can't remember the command. (matter is a little urgent)

Thanks!

First, Stop the SQL Server Agent Service, then start the SQL Server Service and execute it:

RESTORE DATABASE msdb FROM DISK='c:\backup\msdb_backup.bak'

Regards and Happy new Year,

|||

The structure does not differ from MSDE or a greater version of SQL Server 2k. use the kb article here to go the offical way.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-my-msde-database-to-full-blown-sql-server-2000.html a good one.