November 23, 2006 at 6:50 pm
Hi everybody, how can I backup my jobs, can I make a script or something, or what can I do ?...Thanks...
November 24, 2006 at 8:58 am
Backup the MSDB database.
Or
Open Enterprise Manager, expand Management, expand SQL Server Agent. Click on Jobs. Right click on a job, select All Tasks > Generate SQL Script.
Either way will work, but the second one makes it easier to restore a specific job or to restore a job to another server.
-SQLBill
November 27, 2006 at 11:44 pm
Scripting out the Jobs is always better
Pankaj Khanna
Database Administrator - SQL Server 2000
Keep hope to keep you intact...
November 28, 2006 at 10:19 am
And how can I make the MSDB Backup...Thank you all of you...
November 28, 2006 at 10:21 am
And I whant to backup my DTS too to restore them in another Server...how can I do this...
November 29, 2006 at 12:01 pm
You backup msdb just like you do any user database. Either right-click on msdb in Enterprise Manager and select 'All Tasks' then 'Backup database' or use BACKUP command in Query Analyzer.
DTS packages are stored in msdb also, so a database backup will back them up. I prefer to use DTSBackup 2000, available for free download at http://www.sqldts.com/default.aspx?242. It's much easier than backing up and restoring msdb, especially if the destination server already has packages that you don't want to overlay (which a restore will do).
The same advice goes for moving jobs to another server as Pankaj mentioned. If you backup msdb and restore it on another instance, you overlay anything that was already there.
Greg
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply