April 15, 2009 at 1:35 am
Hi,
while my primary server is down i made up my secondary server then how can i transfer job scheduling as well as logins and users.
Thanks,
Shiva
April 15, 2009 at 2:41 am
shivageography (4/15/2009)
Hi,while my primary server is down i made up my secondary server then how can i transfer job scheduling as well as logins and users.
Once you're primary server is down, I would say it's too late for this, unless you've sripted out everything before.
But generally speaking the easiest way is using SSIS with the "Transfer Logins Task" and the "Transfer Jobs task". By default the jobs will be diabled on the destination server.
If you schedule a package to execute these tasks on a daily basis, all you have to day after a failure is to enable the jobs.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply