• If you have Lightspeed or SQL Backup, be sure to check out my sp_ABBackup and sp_ABRestore utilities and the article that explains them, http://www.sqlservercentral.com/columnists/vIacoboni/moreintelligentbackupandrestore.asp.

    They have saved my hide many times. Basically, it will easily let you backup and restore across several databases whether you use Native, Lightspeed, or SQL Backup. Many times you can get away with a single parameter listing the databases you want to backup/restore, and it will figure the rest out.

    Give it a try.

    Vince