When using a SQL Server AlwaysOn, sometimes databases become out sync and need to be resumed.
| Right click the database | |
| Select, New Query |  |
Enter: ALTER DATABASE [database name] SET HADR RESUME |
 |
| Click on Execute |  |
| The database will start synchronizing, this will take some time. |  |
| After a period of time , the database is Synchronized and back online. |  |
Comments are closed