Solved

Job to backup the jobs?

Posted on 2009-04-06
2
258 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

763 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