A blog about real-life SQL Server Troubleshooting, providing solutions that actually work. By a SQL Server Enthusiast.
A severe error occurred on the current command
all the satellite assemblies required are loadable and fully signed
An error occurred while dropping availability group
An error occurred while obtaining or using the certificate for SSL
and it is not possible to create a self-signed certificate
Availability Group does not come up
Availability Group does not come up on one instance
Availability Group does not failover
Availability Group Not Synchronizing\Recovery Pending
awe in sql
because of error 9002
Caching in SQL
cannot be started because some of the database functionality is not available in the current edition of SQL Server
Cannot insert the value NULL into column 'servername'
Case sensitive collation
Check for previous errors
Error code 1642
Exit Code Returned: 11009
Failed mirror comes online after restart
failed to find installation media path due to datastore exception in FindSetupFolder()
Failed to launch local setup100.exe: 0x80070003
Failed to obtain the Windows Server Failover Clustering (WSFC) node handle (Error code 5042)
failed to run patch request for instance
how it works
SQL Server 2008 R2
SQL 2008 R2
SQL Server 2005
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL server memory management
Windows Internal Database
Browse by Tags
Tagged Content List
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...
9 Apr 2012
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:- ...
27 Mar 2012
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...
20 Mar 2012
Page 1 of 1 (3 items)
© 2015 Microsoft Corporation.
Privacy & Cookies