dbTalk Databases Forums  

Clustered Active/Active in Single-user mode

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Clustered Active/Active in Single-user mode in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Moglia Michele
 
Posts: n/a

Default Clustered Active/Active in Single-user mode - 05-06-2004 , 01:06 PM






What is the right procedure to start an instance of a clustered Active/Active Sql Server
The online-book unspecifically writes

From a command prompt, enter:
sqlservr.exe -c -

But some KB Technet articles say do start/stop SQL instance only from cluster administrator
So how to do it

Thanks

Michele Moglia

Reply With Quote
  #2  
Old   
Rand Boyd [MSFT]
 
Posts: n/a

Default RE: Clustered Active/Active in Single-user mode - 05-06-2004 , 02:40 PM






For normal operating procedures the proper method is to start from the
Cluster Administator.

Starting from the command prompt with sqlservr.exe -c -m is a trouble
shooting technique. It starts SQL Server as an application in single user
mode and as such would be pretty useless in a production environment.

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


Reply With Quote
  #3  
Old   
Michele Moglia
 
Posts: n/a

Default RE: Clustered Active/Active in Single-user mode - 05-07-2004 , 03:06 AM



Ok but if I have to restore the master db of the clustered sql server instanc
I have to start the instance in single-user mode so can I start from command promp
without any fear or problem

Thank

Michele Moglia

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.