sql server stadard 2012 standanlone to alwayson failover cluster
hello!
We have an standalone installation of sql server 2012 standard and we would like to migrate to alwayson failover cluster. is it posible to do it directly or we need to reinstall sql server ? what would be the best way to move the current databases on local
drive to shared resource ? Is there is any tutorial or video of how to do it ?
Thanks in advance!
Alberto
August 25th, 2015 3:36am
Hi,
Yes, you need to take backup of all DB's and to reinstall the SQL server again, to configure Always on mode you need to follow several steps, please find the links it would be useful for you
http://blogs.msdn.com/b/saponsqlserver/archive/2012/04/24/sql-server-2012-alwayson-part-7-details-behind-an-alwayson-availability-group.aspx
http://blogs.msdn.com/b/sambetts/archive/2013/04/24/sharepoint-2013-and-sql-server-alwayson-high-availability-sharepoint.aspx
- Jubair
August 25th, 2015 3:46am