How to detach System DB in SQL 2000

[DLTaylor]

I want to detach the system db files, when I run the sp_detach_db command I am told I cannot do this.

I have read many threads that suggest; detaching system db is a matter of course.

Any ideas as to why I encounter an error msg - cannot overwrite system databases

 

[JamesLean]

No, you cannot just detach the system dbs. What are you actually trying to achieve?

--James

 

[DLTaylor]

I want to overwrite the system databases with .ldf & .mdf files from back-up .ldf & .mdf files.

i.e. To restore the DTS data which exists within the MSDB.

 

[fredericofonseca]

if you are trying to restore DTS packages then you just need to attache the old MDB to the database, (different name), and then copy everything you need from the correct dtspackages tables into the current system mdb.

Easy to do.


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com