February 1, 2010 at 5:23 am
Hi all,
I have the crash in the test server i want to take backup for jobs and also i want to take the backup jobs for the live server also,
I have to shut down the services also please help me on this topic
February 1, 2010 at 5:27 am
Can you elaborate a little bit more on your problem so someone can help you?
Are you trying to take a backup of the jobs from Production live server?
February 1, 2010 at 6:09 am
yes i want to take the backup of jobs from production live server and also in the test sever
February 1, 2010 at 6:58 am
If you just want to backup the jobs, you can script the jobs.
Here is a link that shows you how to do it.
What happened to the test server? Do you have backups?
February 1, 2010 at 7:29 am
I'm still confused as to what is being asked. How about more detail instead of a single line vaguely worded question. What are you trying to do?
February 1, 2010 at 7:39 am
Agree with Lynn, it's vague to give a straight answer.
If you need to get the jobs on the test server, you could get it back from latest backup of msdb (if you have one)..
If you get the jobs scripted from production server beware, they might be different, since your production server might have Log backup Job at every 10 minutes which you may not need on the Test Server..
Not only this there might be many other things that would fail on the test server if you just script from the prod and move to test server...
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply