Streamline Log Shipping Failovers: DR Made Just For You…

Question

Streamline Log Shipping Failovers: DR Made Just For You…

MicahNikkel

SSC-Addicted

Points: 476
More actions
September 8, 2015 at 12:04 am

#399006

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

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

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

winfrid.beute SSC Journeyman Points: 94 More actions · Answer 1

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 More actions · Answer 2

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 More actions · Answer 3

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 More actions · Answer 4

Perfect!
Thank you, great scrip.

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

MicahNikkel SSC-Addicted Points: 476 More actions · Answer 5

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 More actions · Answer 6

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 More actions · Answer 7

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