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