Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jooorj
Posting Yak Master
126 Posts |
 Posted - 2011-09-24 : 06:30:13
|
| how can I restore all jobs from sql 2005 , to new instance in another Server,plz help me urgent. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-09-25 : 02:42:52
|
| not workI need to restore all jobs from sql 2005 to new Server with sql 2008.what exactly should I do ?Urgent |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-25 : 02:52:20
|
| why it didnt work? what error did you get?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
vmvadivel
Yak Posting Veteran
69 Posts |
Posted - 2011-09-25 : 03:07:11
|
| Step 1: Go to SQL Server Mgmt Studio.Step 2: Expand SQL Server Agent >> JobsStep 3: Hit F7 (or) goto menu View >> SummaryStep 4: Now ALL jobs would be listed out there. Step 5: Make use of Control key and choose all the JOBs you want to script. (OR) If you want to script everything press Ctrl + AStep 6: Right click >> "Script Job as" >> "Create To" >> FileNow you can make use of this file to create these jobs in your SQL Server 2008 server as well. Best RegardsVadivelhttp://vadivel.blogspot.com |
|
|
|
jooorj
Posting Yak Master
126 Posts |
Posted - 2011-09-25 : 08:00:27
|
| Thanks |
|
|
|
|
|
|
how can I restore all jobs from sql 2005