The steps I gave a client for migrating AlwaysOn Availability Group replicas from an old AD domain to a new one after an acquisition, node by node.
SQL SERVER – UpdateHADRResource – Failed to version-copy file – Exception data is: System.IO.IOException
An UpdateHADRResource patch failure in 2017 involved hadrres.dll being used by another process. Review setup evidence before changing files or services.
SQL SERVER Management Studio – Exception of type ‘System.OutOfMemoryException’ was thrown. (mscorlib)
Copying a huge result set from the SSMS grid threw ‘Exception of type System.OutOfMemoryException was thrown’. Why it happens and a better way to export.
SQL SERVER – The header for file Path is not a valid database file header. The PageAudit property is incorrect
SQL Server would not start: model.mdf did not have a valid database file header and the PageAudit Property was incorrect. How I got it running again.
SQL SERVER – SQL Server: Getting OS information using DMV
Need the Windows version SQL Server runs on? Get OS information with the sys.dm_os_windows_info DMV, or read it from the ERRORLOG at startup.
SQL SERVER – Database Mirroring Connection Error 4 – An Error Occurred While Receiving Data: 10054
Investigate a database mirroring connection error with endpoint and login checks. Understand the historical case and current authentication guidance.
SQL SERVER – Error: 566, Severity: 21 – An Error Occurred While Writing an Audit Trace. SQL Server is Shutting Down
SQL Server shut itself down with error 566: an error occurred while writing an audit trace. Here is what the ERRORLOG showed and how to fix it.