Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Cluster question... Expand / Collapse
Author
Message
Posted Thursday, October 11, 2012 2:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi All,
I have a small question?

Scenario :- SQL Server 2008 on cluster environment and i want to restart the SQL server so i bring offline through Cluster admin then my SQL not coming online.

On this situation which are the services should i check ??

Thanks & regards
Satish
Post #1371259
Posted Thursday, October 11, 2012 2:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:11 AM
Points: 6,633, Visits: 14,209
Check the event logs for more info, there's bound to be an error there somewhere

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1371277
Posted Thursday, October 11, 2012 3:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Hi Perry,
I agree with you but he telling if online will not come then which all are services you will check?? and which services are depend on SQL Server??

I am not confusing you but i am not understand his questions....

Thanks & regards
Satish

Post #1371301
Posted Thursday, October 11, 2012 3:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:11 AM
Points: 6,633, Visits: 14,209
If the sql server service will not come online, check that all the dependant resources start successfully, you can see this in failover cluster manager. Take evrything offline and then online them one at a time in sequence. You will need to check the cluster event and application event logs to find out why the instance won't come online.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1371307
Posted Thursday, October 11, 2012 3:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 29, 2013 8:06 AM
Points: 167, Visits: 414
Thanks Perry...
Post #1371311
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse