MS SQL 2000 backup question

[dre003]

Hello,

I cannot seem to find a way to backup certain aspects of my SQL enterprise console. I can easily backup all of the databases but I cannot figure how to backup Data Transformation Services, Management, Replication, Security, Support Services, and Metadata Services.

Does anyone know how to backup these aspects or at least where they are stored so that I can back them up? The Data Transformation Services are most critical because there are many packages and jobs that must be saved so I can restore them in case of a catastrophic event.

Any advice would be greatly appreciated.

Thank you

 

[rsutoratosu]

I could have sworn its in the MSDB, if you backup the system db and restore them to another sql svr, you should see it.

 

[rsutoratosu]

also aftermarket tools, http://www.sqldts.com/ make sure you really have it backup

 

[dre003]

Great! Thank you!

 

[Zargon]

remember to do test restores on occasion to make sure your backups are valid