Wednesday, May 19, 2010

SQL Server 2005 install fails while starting the services up

I was doing a SQL Server 2005 install and it fails at the end of the install when it attempts to start the SQL services. The messages in Event viewer look like the below:

Faulting application sqlservr.exe, version 2005.90.1399.0, faulting module sqlservr.exe, version 2005.90.1399.0, fault address 0x0000000000b323f0.

The application, E:\Program Files\MSSQL.1\MSSQL\Binn\sqlservr.exe, generated an application error The error occurred on 05/19/2010 @ 16:26:00.026 The exception generated was c0000005 at address 0000000001B323F0 (sqlservr!DmpGetClientExport)

Below are the steps to work around this problem:

1. At the time you get the failure to start SQL Sevrver during setup you are presented with a retry option.

2. At this time, replace the SQLSERVR.exe and SQLOS.dll in the BINN folder at your install location from another SQL instance which already has Service Pack 2 installed and then click on 'Retry'.

Immediately patch it with SP3 or the latest SP available

Failed to obtain the resource handle for cluster resource with name or ID 'xxxxxxxxxxxxxxx' error on Availability Group databases

We recently had failures for our Backup Maintenance Plan (performing T-Log backups) and it would fail with the below error message: Message ...