dbTalk Databases Forums  

Re: single user mode

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


Discuss Re: single user mode in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: single user mode - 04-07-2005 , 08:16 AM






First, put the cluster back the way it was originally.

The following steps MUST be done from the node controlling the SQL server
resources.

Using the Cluster admin tool or the cluster command line tool, take the SQL
server service offline. Leave the network and disk resources online.

From the command prompt, start the SQL Server:
sqlservr.exe -s<instancename> -c -d<masterDBpath> -l<MasterLogPath> -m

This will bring SQL server up in single-user mode. You can then use osql or
QA to restore master. I would not try and use Enterprise Mangler for this
purpose

When you are finished, you can stop the server and restart it using the
cluster admin or command-line tool.

Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator

"¼*Áö¿µ" <jyseo079 (AT) hotmail (DOT) com> wrote

Quote:
Hi~ everyone.

my two sql server were configured clustering service
after that, in order to try to restore master database i changed from
multi
user mode to single user mode.

but something happened.
anybody couldn't access that database to enterprise manager and query
analizer.(denied access)

so i checked out which application had a processor for sql server.
mscs(clustering service) had had a sql processor, so anybody couldn't
access
that database.

how can i restore master database?
Please, give me the answer.





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.