February 5, 2018 at 11:31 pm
Hello Gurus,
We have a request to document and set up DR for about 300 databases to another site.
Ours is a standalone critical Prod DB server, we cannot use always on , and are planning to use logshipping but given that there are 300 DB's this is a mess as well, with a lot of manual work, monitoring, management etc. Do you recommend any third party tools which can handle this?
Thank you in Advance.
February 6, 2018 at 1:40 am
Why can't you use Availability Groups (I assume that's what you mean by AlwaysOn)?
February 7, 2018 at 8:29 am
sqlguy80 - Monday, February 5, 2018 11:31 PMHello Gurus,
We have a request to document and set up DR for about 300 databases to another site.Ours is a standalone critical Prod DB server, we cannot use always on , and are planning to use logshipping but given that there are 300 DB's this is a mess as well, with a lot of manual work, monitoring, management etc. Do you recommend any third party tools which can handle this?
Thank you in Advance.
why cant you use failover groups or failover cluster instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2018 at 1:13 pm
I agree...that a fail over cluster might be your best option IF you can not use ALWAYS ON and log shipping will be a mess as you state
DHeath
February 14, 2018 at 7:03 am
If your only option is to use log shipping i would go with REDGATE for sure!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply