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 memory management
Windows Internal Database
Browse by Tags
sql server 2012
Tagged Content List
How To : SQL 2012 Filetable Setup and Usage
One of the cool things about my job is that I get to work on the latest technologies earlier than most people. I recently stumbled upon an issue related to Filetables, a new feature in SQL Server 2012. To start with, a Filetable brings you the ability to view files and documents in SQL Server, and allows...
10 Nov 2012
Why the registry size can cause problems with your SQL 2012 AlwaysOn/Failover Cluster setup
I recently worked on a very interesting issue, where one of the cluster nodes in an AlwaysOn environment became unstable, and the administrators ended up evicting the node from the Windows cluster as an emergency measure. Ideally, since the primary node/replica was no longer available, the Availability...
25 Oct 2012
SQL Server Cluster Failover Root Cause Analysis–the what, where and how
I know many of you get into situations where SQL Server fails over from one node of a cluster to the other, and you’re hard-pressed to find out why. In this post, I shall seek to answer quite a few questions about how to about conducting a post-mortem analysis for SQL Server cluster failover, aka Cluster...
3 Sep 2012
SQL 2008/2008 R2/2012/2014 setup disappears/fails when installing Setup Support files
I’m sure many of you would have seen this issue when running SQL 2008/2008 R2/2012 setup on a new server. The setup will proceed to install Setup support files, the window will disappear but, strangely enough, the next window never shows up. Here’s what you need to do: Click on start...
7 May 2012
Page 1 of 1 (4 items)
© 2014 Microsoft Corporation.
Privacy & Cookies