If primary side of Availability Groups (AG) is down and can not be online, you can perform failover operation. When primary side is down, probably, you can see state of Availability Groups at the secondary side like below. Failover Steps If you get an error after click Failover button, probably your AG has a problem….
Tag: SQL Server Availability Group
MsSQL Server 2012 Availability Groups (AG) Force Manual Failover
When you can not access primary side of AG and you can not run failover on second side (disaster side), you can perform force manual failover operation on second side. You have to know that force manual failover operation can cause loss data which is able to last some database operation. Failover State When primary…
SQL Server 2012 AlwaysOn Availability Groups Insallation and Configuration
Always On Availability Group is a new feature in SQL Server Database with 2012 release. Before this feature, we was using database mirroring feature in SQL Server 2005. But, mirroring has some limitations and weaknesses. and mirroring feature will be disabled near future. AlwaysOn Availability Groups Features Multi or Single Database Failovers Multiple Secondaries Active…