New answers tagged availability-groups
You can backup on any secondary replica if they are connected to the primary replica AND the state is either SYNCHRONIZED or SYNCHRONIZING. It seems that you should check the connection to the primary replica. Please take a look in the sql server's error log.
It depends on your downtime window. My preferred steps would be : -- take full backup from sql 2008 R2 and restore it on 2012 server. -- do all the post restore steps. -- Add the database to Availability Group. Possibly (with modifications as per your environment), you can use automatically add databases using T-SQL script.
Top 50 recent answers are included