Solved

Job to backup the jobs?

Posted on 2009-04-06
2
249 Views
Last Modified: 2012-05-06
Just wondering if its possible to make a backup job that backs up your jobs in MSSQL server 2005.. I've got quite a few job scripts I wouldnt want to lose in a server crash...
0
Comment
Question by:CantonIT
2 Comments
 
LVL 19

Accepted Solution

by:
jss1199 earned 125 total points
ID: 24080101
If you have built a maintenance plan for your BU job, simply export the mainteance plan from SSIS.  http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/52d71331-908d-4d5e-a14a-c665ce4cbc6a/
0
 
LVL 3

Assisted Solution

by:Popeyediceclay
Popeyediceclay earned 125 total points
ID: 24080120
Also have a look at this:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_23137494.html

"Backup msdb database. Your jobs, steps and schedules are there."
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now