Restrict Access Suddenly Active

I got called in on Monday because people couldn't get into
our SQL Server application. It's SQL Server 2000. After
talking to someone (I'm new to the application) I found
that the 'Single user' option for the database in
Enterprise Manager had been checked. Now I can't think
that anyone would have gone up to the server between
Friday and Monday (I was in at the weekend too, and didn't
touch the server). So I'm wondering how it might have
suddenly become checked and ruin my day off... :-)
TimA maintenance plan with the "repair minor problems" option set will do this.
"Tim Gowen" <tim.gowen@.rafmuseum.org> wrote in message
news:152b01c46f2c$30f715c0$a301280a@.phx.gbl...
> I got called in on Monday because people couldn't get into
> our SQL Server application. It's SQL Server 2000. After
> talking to someone (I'm new to the application) I found
> that the 'Single user' option for the database in
> Enterprise Manager had been checked. Now I can't think
> that anyone would have gone up to the server between
> Friday and Monday (I was in at the weekend too, and didn't
> touch the server). So I'm wondering how it might have
> suddenly become checked and ruin my day off... :-)
> Tim

Restrict Access Suddenly Active

I got called in on Monday because people couldn't get into
our SQL Server application. It's SQL Server 2000. After
talking to someone (I'm new to the application) I found
that the 'Single user' option for the database in
Enterprise Manager had been checked. Now I can't think
that anyone would have gone up to the server between
Friday and Monday (I was in at the weekend too, and didn't
touch the server). So I'm wondering how it might have
suddenly become checked and ruin my day off... :-)
Tim
A maintenance plan with the "repair minor problems" option set will do this.
"Tim Gowen" <tim.gowen@.rafmuseum.org> wrote in message
news:152b01c46f2c$30f715c0$a301280a@.phx.gbl...
> I got called in on Monday because people couldn't get into
> our SQL Server application. It's SQL Server 2000. After
> talking to someone (I'm new to the application) I found
> that the 'Single user' option for the database in
> Enterprise Manager had been checked. Now I can't think
> that anyone would have gone up to the server between
> Friday and Monday (I was in at the weekend too, and didn't
> touch the server). So I'm wondering how it might have
> suddenly become checked and ruin my day off... :-)
> Tim

Restoring Master DB to a clustered server

Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
TedmondHello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond

Restoring Master DB to a clustered server

Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
Tedmond
Hello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond

Restoring Master DB to a clustered server

Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
TedmondHello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond