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 |
|
bobanjayan
Yak Posting Veteran
67 Posts |
 Posted - 2004-08-05 : 05:13:31
|
Friends,Can you tell me how can I take backup of Jobs?I have around 30 jobs scheduled for night run.I can't restore MISDB backup on another machine.Error - quote:
The backup of the system database on device C:\DBBackup\msdb.bck cannot be restored becauseit was created by a different version of the server (134218488) than this server (134217922).Restore is termination abnormally. quote:
I didn't find any version difference..How can I export all jobs from one machine and import it in another machine? |
|
|
MuadDBA
628 Posts |
Posted - 2004-08-05 : 13:24:24
|
| Go to management folderOpen SQl Server AgentOpen JobsRight click on some whitespace in the jobs area.Select "script all jobs" |
 |
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-08-06 : 02:48:09
|
| Yes. I did already. But running this script to restore on another server,it error messages like following.-----------------------------------------------Server: Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 198The specified '@owner_login_name' is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]).-----------------------------------------------Out of 23 jobs 18 jobs restored.4 jobs are disabled.Why it doesn't restore 5 jobs?Why it is giving error messages?Please help. |
|
|
|
bobanjayan
Yak Posting Veteran
67 Posts |
Posted - 2004-08-06 : 02:54:48
|
| Ok. I got it.I am sorry for the stupidity.It was clearly written in the error message.I changed the the value of '@owner_login_name' to 'sa' (valid user name). Now the problem is solved.Thanks a lot. |
|
|
|
|
|
|
Backup & Recovery of Jobs - Urgent