Post reply

Additional Log Shipping secondary server - how to

  • October 7, 2013 at 2:15 pm

    #299470

    I have an existing 2008R2 primary server shipping logs from ODS to a third server. I want to add my Data Warehouse server to the existing log shipping scheme as a secondary server. I know this is likely an idiotic question to those who have done it a bazillion times, but how can this be done?:ermm:


    Doug Brashear

  • October 8, 2013 at 2:35 pm

    #1656917

    Hi Doug,

    Right click the database and choose "Tasks->Ship Transaction Logs"

    This should all be already set up with your current configuration. Under Secondary databases it will list your current secondary and the database it's being shipped too. There's an Add... button underneath that box. Just click that and then set it up as if it's the first set of logshipping you are doing.

    Hope that helps,

    Rob

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

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