Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We currently use a fairly basic script we wrote to log ship our databases to our DR site (and back again) but want to move to a better solution. We initially discounted the inbuilt logshipping solution due to the fact we would have to set it up manually for each database (we have about 40 and will have 80 before the end of the year all about 2-5GB in size) and also cannot get it to run in an order so they all take up bandwidth at the same time. Our current problem is that if the secondary server 'misses' a log it goes wrong and we have to transfer the whole database. I guess my question is - are we on the wrong track here? We dont have vast amounts of cash to burn on a solution only our own time and patience :-). We basically need to get to and from our DR site within 30 minutes and for a test we are worried about dataloss (but for a real disaster we dont mind). Id appretiate any ideas or suggestions.

Chris

share|improve this question
    
How big are the databases? –  Bryan S. Dec 8 '09 at 15:52

4 Answers 4

Red-Gate SQL Backup does log shipping. I've only sampled it, but the interface and scheduling within it may be what you need. They have a trial version as well.

share|improve this answer

I'm not understanding the "...cannot get it to run in an order so they all take up bandwidth at the same time...". This reads to me like your wish is to manage when the logs are copied, that you wish to minimize job collisions here. Also, you don't mention the amount of latency that is tolerable. I could see how the built-in log shipping set up might be undesireable given the setup on this many databases but it would give you the ability to schedule the when the copy jobs run for each shipped log. Not what you have asked for but in the absence of a bulletproof custom script or third party tool it is an option.

share|improve this answer

We have solved basic logshipping by just using sqlserver 2008s inbuilt logshipping. This has enabled us to specify times for each job to run which is great.

share|improve this answer

it isn't all that hard to write custom log shipping scripts to account for this. i've posted some scripts up on searchsqlserver.com that you can use.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.