A client clicked Start Mirroring and got Mirroring Error 1412: the remote copy has not been rolled forward far enough. Here is what it means and how to fix it.
SQL SERVER – Installation Error – File Format is Not Valid
At the license agreement step, SQL Server setup stopped with ‘File format is not valid’. Here is what caused this Installation Error for my client and the fix.
SQL SERVER – syspolicy_purge_history job failing step: Erase Phantom System Health Records
A client’s syspolicy_purge_history job kept failing at the step Erase Phantom System Health Records. Here is what the job does and how to fix the failure.
SQL SERVER – Setup Closed with Exit Code 0x80004005
Setup for SQL Server 2008 R2 SP3 closed with exit code 0x80004005 and wrote no summary log. Here is where to find sqlsetup.log in %TEMP% and what it showed.
SQL SERVER – Exception Code c0000005 While Starting SQL Service
A reader’s SQL Server would not start and wrote no ERRORLOG. Starting it from the command prompt showed Exception Code c0000005. Here is how we found the cause.
SQL SERVER – Unable to start SQL Server Agent – Failed to Initialize SQL Agent log
My friend changed SQL Agent parameters and then the service would not start: failed to initialize SQL Agent log. Here is where to look and how we fixed it.
Resolving State: Why an AlwaysOn Availability Group Gets Stuck
Resolving state is the intermediate state of an AlwaysOn availability group during a role change. If the transition fails, the group stays there and the database is not accessible. Here is what the ERRORLOG showed in one case.