Streamline Log Shipping Failovers: DR Made Just For You…

  • MicahNikkel

    SSC-Addicted

    Points: 476

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

  • winfrid.beute

    SSC Journeyman

    Points: 94

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

  • MicahNikkel

    SSC-Addicted

    Points: 476

    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.

  • saxena.akash87

    Valued Member

    Points: 72

    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!!

  • DBAGeek

    Valued Member

    Points: 64

    Perfect!
    Thank you, great scrip.

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

  • MicahNikkel

    SSC-Addicted

    Points: 476

    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.

  • protasevitch

    Grasshopper

    Points: 23

    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

  • MicahNikkel

    SSC-Addicted

    Points: 476

    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