There are various utilities for scripting MS SQL Server objects : Tables , Procedures , Functions .... etc ...
Small piece of code that will allow you to script all jobs from your SQL Server using SQL DMO object.
Load Backup History from Backup File
This script creates a stored proc to verify all backups in a media set and load their history into MSDB. I use this frequently when I get backup files from clients and want to use Enterprise Manager's intelligent restore selection to quickly get the database restored on a test machine.
2003-03-11
301 reads