New answers tagged availability-groups
Does it mean that former primary replica (A) will become primary replica automatically? No, all that means is when your replica comes back into the picture, and when the Availability Group database gets back in a SYNCHRONIZED state that it would be failover ready. That operation will not happen automatically. You indeed would have to either do this ...
I pulled the oldest full backup I could find and was able to restore that over the Restoring db using: RESTORE DATABASE [ZOMBIEDB] FROM DISK = N'D:\ZOMBIEDB.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 5 I was then able to delete the restored database.
After a forced failover testing with async mode, do I need to rebuild my old primary database? I'm not sure exactly what you mean by "rebuild" the database, but provided the databases are still in a working condition then you shouldn't need to take any actions like that. What you're seeing, by performing a forced failover, is by design. If you do a ...
You need to set that in the AG ROLE properties as below : Windows server 2012
Top 50 recent answers are included