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. |