RE: Failover fails after applying MS03-031 patch

From: Chris Skorlinski (ChrisSkor_at_Online.Microsoft.com)
Date: 08/22/04 

Date: Sun, 22 Aug 2004 07:50:56 GMT

Hi Cedric,

To troubleshoot,

1) Take SQL Server offline
2) Move SQL group to the second node.
3) Bring the Disk, IP, and Name online.
4) From a command window, start SQL Server using the -C parameter.

This will start SQL Server as an application, outside the cluster admin
control. Note any errors or warning starting SQL Server. Check the SQL
errorlog for status while starting. You sould also be able to connect
using Query Analyzer while SQL Server is started with -C.

Chris Skorlinski
Microsoft SQL Server Support
Please reply directly to the thread with any updates.

This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • RE: cluster resource in resource group failed
    ... Keywords: Classic,Audit Failure ... SQL Server is terminating in response to a 'stop' request from Service ... OnlineThread: ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 on Windows 2003 cluster - URGENT HELP
    ... The log files are plain-text human readable. ... >> Microsoft SQL Server MVP ... >>> do not come online even though I can see them in clusteradmin from ... >>> I feel would come online once SQL server resource comes online. ...
    (microsoft.public.sqlserver.clustering)
  • Failover fails after applying MS03-031 patch
    ... applied successfully SP3a to both nodes (Failover to second node still ... Ms03-031 cummulative patch. ... But when I initiate a "move group" in Cluster Admin, the SQL Server ... OnlineThread: ...
    (microsoft.public.sqlserver.clustering)
  • RE: Starting SQL Server Resource Group failed
    ... server if that was the case then your cluster will always fail as this group ... The installation of the Virtual SQL Server 2005 went well, ... "All resources did not come online and therefore you will need to manually ... If I want to bring the Resource Group online, the SQL Server Starts, but a ...
    (microsoft.public.sqlserver.clustering)
  • RE: Starting SQL Server Resource Group failed
    ... server if that was the case then your cluster will always fail as this group ... The installation of the Virtual SQL Server 2005 went well, ... "All resources did not come online and therefore you will need to manually ... If I want to bring the Resource Group online, the SQL Server Starts, but a ...
    (microsoft.public.sqlserver.clustering)