Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Custom Log Shipping


Custom Log Shipping

Author
Message
Marcel van Pinxteren
Marcel van Pinxteren
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 13
We had problems with files being locked. After the backup and after the zip just add a little wait (e.g. 1 minute).
Alex Tomic
Alex Tomic
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 30
This approach seems very well thought out. I would like to test it, but the link to scripts appears to be broken (404 not found).

Can someone provide an updated link?

Thanks!
Jason Steele
Jason Steele
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 11
Alex Tomic (4/20/2008)
This approach seems very well thought out. I would like to test it, but the link to scripts appears to be broken (404 not found).

Can someone provide an updated link?

Thanks!


Hi Alex,

I've uploaded it to my SkyDrive at http://cid-e39114477b2c887f.skydrive.live.com/browse.aspx/Public.

I've been using for over a year now (with some tweaks). It's pretty good but there's quite a few hard coded things that should be pulled out into a settings table and also here is no automatic retry if an FTP fails - which can be surprisingly often if you are log shipping 30 databases at every 15 minutes!

But its the best one I have found at the right price Wink - so many thanks to Chris Kempster for sharing it.



Jason
jando999
jando999
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 6
HI,

The link to the the zip file containing the code and scripts is broken.

Any ideas where I can get the source for this?

Cheers
James
jando999
jando999
Grasshopper
Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)Grasshopper (10 reputation)

Group: General Forum Members
Points: 10 Visits: 6
jando999 (3/17/2009)
HI,

The link to the the zip file containing the code and scripts is broken.

Any ideas where I can get the source for this?

Cheers
James


Ignore me, must learn to read previous posts
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search