February 15, 2008 at 5:39 am
I have at current, approximately 100 databases. This will increase to any number of hundreds eventually but likely 400 ish by the end of the year.
My question is simple: Will Log Shipping work on this many databases?
February 15, 2008 at 7:20 am
nate I'm not aware of any limits on log shipping, as long as you have the bandwith and processor power I don't see any reason why it won't work.
That is the question you must answer though, do you have the processor power and bandwidth to ship logs for that many databases.
Marvin Dillard
Senior Consultant
Claraview Inc
February 15, 2008 at 7:57 am
Excellent. As we speak, we are ordering two new servers - as far as i am aware they are going to be high spec, so i dont see a problem here. Thanks for the info 🙂
If anyone else has any input, feel free to advise me here 😛
February 27, 2008 at 12:12 pm
Don't go configuring log shipping for 100 of databases in a single server. i am sure you are going to end up in a hardware bottleneck.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
February 28, 2008 at 1:17 am
Yes. Chances of getting a hardware or even software failure is high. Why did u choose log shipping ?
"Keep Trying"
February 28, 2008 at 1:24 am
Mostly i was just enquiring about it. No matter what i look into and research, i cant seem to find a suitable answer to my problem. I have thought about Mirroring and replication also but it seems like like none of these "solutions" will support the number of databases i need it to. Seems the same applies with Log Shipping 🙁
Thanks for the update though.....answered my question 🙂
February 28, 2008 at 7:09 am
you can do log shipping for this number of databases in theory, theres nothing to prevent you. there will be an i/o hit on the backup disk(so keep seperate from databases) and on the network.
it will also be a pain just to set up log shipping for this number of databases.
If this is for resilience I think a cluster is your best bet for this scenario.
mirroring is out of the question, there are limitations on the number of databases with that.
---------------------------------------------------------------------
February 28, 2008 at 8:50 am
You can do a clustering in this case. Also you can think about doubletake replication which suits your req.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply