SQL Server Resource database corruption–yes, it’s possible

It’s very rare that I run into an issue with the Resource database, and the one I ran into recently was rarer still. But before I get into the nitty-gritty of the issue, let us begin by outlining a few details about the resource database: The Resource database The resource database is a hidden system…

20

SQL 2005 Patch on cluster might fail with “No Passive nodes were successfully patched”

This is one of those “rare” setup issues you might run into, on a “Bad luck” day. The patch fails, and in the summary.txt, you see this at the bottom:- Summary      No passive nodes were successfully patched      Exit Code Returned: 11009 Looking at the hotfix.log, you find this:- 03/18/2012 11:57:51.200 MSP Error: 29527 …

2

VSS backups might cause SQL to generate Non-Yielding Scheduler dumps if Backup verification is turned on

Found an interesting Non-Yielding scheduler recently. Opened the dump, and found function calls related to backup verification (such as validating the file name, verifying that the drive is part of the cluster group, etc.) at the top of the stack: Child-SP          RetAddr           Call Site 00000000`29cda478 000007fe`fe21a776 ntdll!ZwAlpcSendWaitReceivePort 00000000`29cda480 000007fe`fe2bcc74 rpcrt4!LRPC_CCALL::SendReceive 00000000`29cda540 000007fe`fe2bcf25 rpcrt4!NdrpClientCall3 00000000`29cda800 000007fe`f8902196…

3