Mad-Dog (4/13/2016)
Hi,I've SQL Server 2012 STD and SQL Server 2014 STD and i need to implement some kind of DR or HA to it so i can reduce the load from the production server by running some reports and other stored proc and even backup on the DR or HA server (lets call it DR).
the problem is - while the DR is sync with the production server the DR server needs to be available almost instantly.
can it be done?
p.s - if the only chance is by running the SQL server in ENT edition it can be done.
THX
Does the prod server and the dr server have the same version of sql server or is one 2012 and the other 2014?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉