By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,715 Members | 1,815 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,715 IT Pros & Developers. It's quick & easy.

SQL Server in single user mode??

P: n/a
Hello Faculties

When doing recovery after loss of data files, one would like to
start SQL Server in single user mode. Is this possible?

Thanks in advance
Debashish
Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can start SQL Server in single-user mode with the '-m' parameter. This
is usually done by invoking sqlservr.exe from the command prompt rather than
as a service. See the Books Online <adminsql.chm::/ad_1_start_8m43.htm> for
more information.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"debashish" <de****************@rediffmail.com> wrote in message
news:bb**************************@posting.google.c om...
Hello Faculties

When doing recovery after loss of data files, one would like to
start SQL Server in single user mode. Is this possible?

Thanks in advance
Debashish

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.