Restarting the SQL Server Service

#1

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

#2

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

This posting is provided "AS IS" with no warranties, and confers no rights.
© 2008 Microsoft Corporation.
All rights reserved.

#3

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

This posting is provided "AS IS" with no warranties, and confers no rights.
© 2008 Microsoft Corporation.
All rights reserved.

#4

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

This posting is provided "AS IS" with no warranties, and confers no rights.
© 2008 Microsoft Corporation.
All rights reserved.

#5

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

This posting is provided "AS IS" with no warranties, and confers no rights.
© 2008 Microsoft Corporation.
All rights reserved.

#6

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

This posting is provided "AS IS" with no warranties, and confers no rights.
© 2008 Microsoft Corporation.
All rights reserved.

#7

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

This posting is provided "AS IS" with no warranties, and confers no rights.
© 2008 Microsoft Corporation.
All rights reserved.

#8

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

#9

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?

#10

Sean,

MSCS Cluster Service monitors the current state of any resource that a
cluster manages. In the case of a SQL Server-based MSCS environment, the
Cluster Service monitors the SQL Server service. The Cluster Service
detects stoppages of these services, but it can't distinguish between a
user-initiated shutdown and an unplanned failure. So you must stop and
start SQL Server through the Cluster Administrator rather than the Control
Panel or the standard Service Control utility.

The SQL Server service is shutdown when you take the SQL Server resource
offline in the cluster administrator.

..Sanjay

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

Quote:

Thread-Topic: Restarting the SQL Server Service
thread-index: Aciag9cgwVNDyE1YTgK56B52hTZLaA==
X-WBNR-Posting-Host: 207.46.19.168
From: =?Utf-8?B?U2VhbiBTbmlkZXI=?= <SeanSnider (AT) discussions (DOT) microsoft.com
Subject: Restarting the SQL Server Service
Date: Wed, 9 Apr 2008 13:54:02 -0700
Lines: 6
Message-ID: <FDF9E047-91A0-4BDB-969A-60CB1DE481A2 (AT) microsoft (DOT) com
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
Newsgroups: microsoft.public.sqlserver.clustering
Path: TK2MSFTNGHUB02.phx.gbl
Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.clustering:2991
NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
X-Tomcat-NG: microsoft.public.sqlserver.clustering

Are there any reasons why the SQL Server Service of an SQL Server 2005
Cluster (active/passive), should not be restarted using Management Studio?

Is there any reason why the SQL Server Cluster should be taken offline
before restarting the service?