Streamline Log Shipping Failovers: DR Made Just For You…

  • Comments posted to this topic are about the item Streamline Log Shipping Failovers: DR Made Just For You…

  • I have trouble creating the scripts, the folder is created, however the folder where the scripts should show up stay's empty.

  • Thank you for sharing your experience with the script. Please contact me directly at the email address within the script and I'll be happy to try and help. If it turns out to be something that would be good to share I can always post another reply to this question. Thanks.

  • Hi Micah,

    Thank You for this awesome solution.

    I was wondering if you have any solution to set up Log Shipping for multiple databases using a script. I tried to find it on online forums but coudn't found anything. I need to set up log shipping between SQL 2008 R2 and SQL 2014. I would greatly appreciate if you can assist with the script for setting up Log Shipping for multiple databases.

    Thanks in advance!!

  • Perfect!
    Thank you, great scrip.

    I think it would be more elastic with one more parameter - database name 🙂

  • DBAGeek - Wednesday, March 22, 2017 3:51 PM

    Perfect!
    Thank you, great scrip.

    I think it would be more elastic with one more parameter - database name 🙂

    Thank you for the feedback.  I am working on the next iteration of this solution and will definitely add this functionality to the list of things I want to include.

  • winfrid.beute - Tuesday, December 22, 2015 7:29 AM

    I have trouble creating the scripts, the folder is created, however the folder where the scripts should show up stay's empty.

    I have same troubles fix it by editing some lines
    add this at the top
    DECLARE @InstanceToRunBCP VARCHAR(100)
    SET @InstanceToRunBCP = 'mysrv\myinstance'

    correct each line contains BCP
    SET @Execute_ScriptToExport = 'BCP ' + QUOTENAME('SELECT SQLToRun FROM Tempdb.dbo.LS_Step01', '"') + ' QUERYOUT ' + @ScriptsLocation + '\Streamline_LS_Failovers_' + @FormattedDateTime + '\01.sql -T -c -S ' + @InstanceToRunBCP

  • Thank you for sharing your modifications so I can take them into account for the next version.  I appreciate it!

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

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