Any Third Party DR solutions for SQLServer 2014 Standard Edition

Question

Post reply

Any Third Party DR solutions for SQLServer 2014 Standard Edition

kochu.vinod

Old Hand

Points: 356
More actions
July 16, 2015 at 12:24 am

#298886

Hi Friends,
We are planning to implement Disaster Recovery for our SQL servers, We have SQL2014 Enterprise & Standard edition.
For Enterprise servers we are going to use Alwayson. Due budget constrain we can’t convert existing Standard edition into Enterprise. Our objective is to have instance level recovery & with near zero data loss. We had evaluated some of the third party tools for DR solution (ca arcserve , symantec ,Dell NVFR tool etc.) . I need some suggestion from your side.
1)What would be the best solution for SQL 2014 Standard DR solution.
2)Readable Secondary Server
3)Instance & single database level recovery
4)Network throttling
My total Delta change across all servers is around 1 TB per day. We have also initiated to reduce delta changes. If possible we would like to use my secondary servers as reporting
I appreciate all your responses. Thanks!
Regards,
Vinod Kochu

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

praveen_vejandla SSCrazy Points: 2069 More actions · Answer 1

Database mirroring, log shipping are two options.

Cloud is another option.

https://www.simple-talk.com/sql/backup-and-recovery/high-availability-and-disaster-recovery-for-small-businesses/

SANless clusters is another option

http://us.sios.com/2015/02/dr-journal-cayan-protects-business-critical-applications-sios-sanless-clusters/

praveen_vejandla SSCrazy Points: 2069 More actions · Answer 2

Also, some of the SAN vendors provide storage based replication (ex: NetApp snap mirror etc).. But they may be

costlier.

Luis Cazares SSC Guru Points: 183706 More actions · Answer 3

You say Disaster Recovery but you only mention High Availability solutions.

What do you really need?

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

kochu.vinod Old Hand Points: 356 More actions · Answer 4

Thanks for the reply

Since we are looking for a DR solution, We can’t use Databases mirroring for Sql Standard edition. As Standard edition gives only synchronous mirroring and the same is not applicable for WAN network due performance latency . In order achieve near data loss this Log shipping won’t help us

Regards,

vinod Kochu

kochu.vinod Old Hand Points: 356 More actions · Answer 5

We are looking Far Disaster Recovery solution only, However our object is to have near zero data loss with lesser downtime. We have mix SQL Editions of Standard & Enterprise. For enterprise edition servers I can use Alwayson with Asynchronous mode which will provide me near zero data loss and fast failover options . My concerns is for Standard Edition. Because it doesn’t support Asynchronous mirroring. If we use Logshipping there could be 10 to 15 min of data loss. Which is unacceptable for our OLTP environment. Is there any alternative which can provide me near zero data loss and lesser downtime.