Installing a service pack on a clustered instance failed with EnumeratorException: Failed to retrieve data for this request. Detail.txt showed the cause.
SQL SERVER – Availability Group Missing or Deleted Automatically?
After a network issue, two availability groups vanished from SSMS. Here is how the logs explained an availability group missing or deleted automatically.
SQL SERVER – Maintenance Plan – Could not load type ‘Microsoft.SqlServer.Dts. Runtime.Wrapper. IDTSPackageSigning100’ from Assembly
Fix the maintenance plan error in SSMS, could not load type IDTSPackageSigning100, when existing plans run fine but you cannot modify them.
SQL SERVER – Errorlog The Server was Unable to Initialize Encryption Because of a Problem with a Security Library
SQL Server would not start, and the ERRORLOG said the server was unable to initialize encryption because of a problem with a security library.
SQL SERVER – FIX : Error Msg 8672 – The MERGE Statement Attempted to UPDATE or DELETE the Same Row More Than Once
While preparing a demo I hit Msg 8672: the MERGE statement attempted to UPDATE or DELETE the same row more than once. Here is why and how to avoid it.
How to Get Status of Running Backup and Restore in SQL Server? – Interview Question of the Week #113
How do you check the status of running backup and restore operations? Here is the script I built to see every backup and restore running on the server.
Print Status Messages Using RAISERROR WITH NOWAIT
To see progress while a long script runs, use RAISERROR WITH NOWAIT instead of PRINT. This post builds a progress loop, formats values with placeholders, and shows the percent sign trap that garbles a message. It also explains how severity decides whether a message stays inside a TRY block, and where the 2,047 character limit cuts a message.