Solved

Import/Export SQL jobs to different system in SQL 2005

Posted on 2009-05-07
11
1,035 Views
Last Modified: 2012-05-06
I have two SQL 2005 servers. I wanted to copy all the SQL jobs from one SQL server to another SQL server. please tell me the easist way? Can i this be done using Import/Export data wizard for msdb?

thanks
0
Comment
Question by:tech2010
[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
  • 5
  • 3
  • 3
11 Comments
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24324616
0
 

Author Comment

by:tech2010
ID: 24324638
i am not registered on sqlservercentral.com so please tell me something else. thanks
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24324661
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:tech2010
ID: 24324776
by looking this article. I am not sure that if that should be the case for system database. Becuase all it tell you that we can create a script for any database which brings schema and everything. But i am scared to do this way. All i want to do is to pull over my SQL jobs from one physical SQL 2005 box to other physicall SQL 2005?
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24324901
How about backup & restore?
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24324911
I am sorry there is no such option still available.
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24324920
>>How about backup & restore?<<

are you sure backup will take backup of SQL Agent job as well? ;)
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24324951
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24324964
the link you provided says the same as my link ;) generate the script and move it. not direct export like we used to do for table.
0
 

Author Comment

by:tech2010
ID: 24325704
is it ok if i right click on each job and generate a script and then run that script on the new server?
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24325718
yes, perfectly OK.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

740 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