Nicole

as far as DTS/SSIS goes, we use DTSBackup2000. We execute an overnight batch of the command line exe to copy all server-based DTS packages to the DR site.

We also decided early on that all SSIS packages should be file based.

All file-based DTS and SSIS packages are xcopied to the DR site in a separate script.

Logins are also scripted out, including IDs and hashed passwords, and sent to DR overnight.

Agent jobs are somewhat problematic in that they are copied manually on creation. We haven't pursued this much more since our set of jobs is fairly static.