0

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

1
  • How big are the databases?
    – Bryan S.
    Dec 8, 2009 at 15:52

4 Answers 4

0

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.

0

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.

0

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.

0

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .