Solved

Job to backup the jobs?

Posted on 2009-04-06
2
254 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

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

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…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

828 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