Sometimes AOAG configuration stuck in resolving state and its secondary Replica does not come online. When you check the Alwayson Availability Group configuration, you find it showing in resolving state after Automatic failover of AOAG Configuration. Let us get the...
I saw SQL Server error 14258 today while i was diagnosing my log shipping issue in which primary and standby servers was not in sync. I checked log but i didn’t find anything even SQL Server agent was running and...
Whenever you get the issue “Msg 7321” make sure your security context is correctly supplied. Otherwise you will get below error. Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing a query for execution against OLE...
The error 1813 comes when corrupt transaction log are attempted to attach to new server. Error details are given below: Msg 1813, Level 16, State 2, Line 1, Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted. If you...
