June 22, 2014 at 11:59 pm
HI,
Can we configure Mirror setup with alwayson features on SQL 2012?
can it be done automatic failover over method, once principle DB server down?
How can be application automaticallay re-direct to secondary DB server?
application using ODBC connection string but not using web.config file.
Please suggestion me and gudie me from experts advise.
Thanks
ananda
June 23, 2014 at 7:47 am
ananda.murugesan (6/22/2014)
HI,Can we configure Mirror setup with alwayson features on SQL 2012?
can it be done automatic failover over method, once principle DB server down?
How can be application automaticallay re-direct to secondary DB server?
application using ODBC connection string but not using web.config file.
Please suggestion me and gudie me from experts advise.
Thanks
ananda
Don't take this the wrong way, but you are asking questions that show almost no understanding or knowledge of the "Always On" set of functionality in SQL Server. And if you pursue it after getting a few forum posts answered and maybe reading a bit of Books Online you are almost certain to have a (potentially VERY) bad experience!!
1) Mirroring IS the underpinnings of Always On.
2) Database failover CAN be automatic if Principal goes offline.
3) Applications CAN automatically point to the "new" Principal database on failover.
For 2 and 3 above CAN does NOT mean WILL. You have to do some things right to make those things happen as you desire.
I STRONGLY recommend you get help from someone qualified to ensure your HA/DR plan is a) what you actually need/expect/can pay for and b) is set up, tested, monitored and maintained properly!! To do less than that can literally put your company at risk. You also need to be aware of the MANY limitations, issues, etc. that come with Always On.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply