-Sue
On Wed, 13 Nov 2002 04:33:26 -0800, "Kevin Coleclough"
--
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
Quote:> I need to restart my SQL 7 server in single user mode so
> that the master database can be restored to it. I run the
> command sqlservr -m in a command prompt, but the command
> never seems to complete, despite all the messages that
> appear on screen that seem to suggest everything is OK.
> So, the command seemingly continues to run, but the SQL
> Server is not brought back up. Any ideas??
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
3. Couldn't able to start the sql server in single user mode
4. Informix-CLI 2.5 installation help needed!
5. Unable to Start SQL Server 2000 in Single User Mode
6. FoxPro - Inserting records from DBF to another
7. Access Denied to SQL Server after starting in Single User Mode
8. SQL Server 6.5 backup to tape...
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. How to start server i single user mode