by Naveen Samb » Sat, 24 Feb 2001 03:20:28
by Kevin Connel » Sat, 24 Feb 2001 05:27:57
Hello,
I couldn't able to start the sql server in single user mode.
Though I issued a command sqlservr.exe -m from the command prompt,I can't
able to
restrict the users.The agent is also starting. I tried using
sqlservr.exe -m -f
its still behaving the same way.Iam planning to restore the master
database. Any
suggestions or solutions in this regard is highly appreciated.
Thanks,
Naveen Samba,
SQL Server DBA.
by Calvi » Wed, 28 Feb 2001 15:21:11
Quote:-----Original Message-----
Hello,
I couldn't able to start the sql server in single user mode.
Though I issued a command sqlservr.exe -m from the command prompt,I can't able to
restrict the users.The agent is also starting. I tried using sqlservr.exe -m -f
its still behaving the same way.Iam planning to restore the master database. Any
suggestions or solutions in this regard is highly appreciated.
Thanks,
Naveen Samba,
SQL Server DBA.
.
*******************************************
Naveen Samba , I'm experiencing similar problems. How did you get your
server agent to start. The icon isn't even visible on my tool bar near
the system clock like it's supposed to be.
1. HOW TO START SQL SERVER IN SINGLE USER MODE ON CLUSTER
If one needs to restore the master database on SQL Server on a cluster, how
can SQL Server be started with the -m switch?
Or, does the SQL Server virtual server need to be removed before SQL Server
is started in single user mode?
Thanks in advance,
Brian G. Linebaugh
2. Error occured while trying to update the column value
3. SQL 7 Cluster (on W2k) - starting the server in Single User Mode
4. How do i insert several rows to a table ?
5. Unable to Start SQL Server 2000 in Single User Mode
7. Access Denied to SQL Server after starting in Single User Mode
8. Parameters
9. HELP!: How to start SQL Server in Single User Mode
10. Stupid question - starting SQL Server in single user mode (/m)
11. starting sql server in single user mode
12. When Single User Mode is not Single User Mode
13. Won't start in single user mode