Post reply

How to Transfer SQL Agent Jobs from Primary to Secondary in Log Shipping

  • May 7, 2007 at 12:42 pm

    #120002

    Hi,

    I have done the follwoing to Switch from Primary to Secondary Server

    Copied all the Transaction files which are not restored, and with no recovery the transaction log files are been transfered.

    Made database to recovery mode, and available to access.

    Now here i have shift all the SQL Agents jobs from primary to secondary and secondary to primary, how to do this option.

    So that my secondary and Primary server can switch over completely.

    Regards,

    Pavan

     

  • May 7, 2007 at 1:19 pm

    #704761

    Pavan,

    I'd script the jobs and run the script on the secondary server.  You can script jobs by expanding SQL Server Agent in SSMS, click on Jobs, highlight the jobs you want to script, right-click, choose script job as... and create to.

    Greg

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply