Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL 6.5 single user mode

Posted on 2003-03-03
9
Medium Priority
?
254 Views
Last Modified: 2006-11-17
Hello All,
    I am trying to get a system setup that is identical as my current server. I have made the db's, and when trying to restore teh db's to this server from tape, it keeps giving me an error about only the master can be restored while in single user mode. I didn't go in and start the server in SUM, how can I get the server started in normal mode? Thanks all.


~light
0
Comment
Question by:e-zlight
  • 3
  • 2
  • 2
  • +1
8 Comments
 

Expert Comment

by:SQLMonkey
ID: 8057854
You need to start SQL Server with the -m parameter.  Stop the SQL Server service, then open up a command prompt and run:

sqlservr.exe -m
0
 

Author Comment

by:e-zlight
ID: 8058090
Correct, But I need to know how to start it without being in SUM. For some reason it automatically starts in SUM. But that is no longer a problem, as I am starting over. thanks.
0
 
LVL 1

Expert Comment

by:Aycex
ID: 8058131
Also when you are done you must shut down sql server and restart it, not just stop services.  Then it will be back in the correct mode.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Expert Comment

by:modulo
ID: 8183509
Dear expert(s),

A request has been made to close this Q in CS:
http://www.experts-exchange.com/Community_Support/CleanUp/Q_20557623.html

Without a response in 72 hrs, a moderator will finalize this question by:

 - Saving this Q as a PAQ and refunding the points to the questionner

When you agree or disagree, please add a comment here.

Thank you.

modulo

Community Support Moderator
Experts Exchange
0
 
LVL 1

Expert Comment

by:Aycex
ID: 8183549
I don't think this is fair ti the person that answered the question correctly (not me) I thought it was sqlserver.exe -c -m, but that must be for 7.o or later.  He asked the question and got the answer he asked for wether he chose to start over or not does not invalidate the question the points need to be awarded to the correct answer.
0
 

Author Comment

by:e-zlight
ID: 8183697
I'll award the points if you can clearly tell me who answered my question? I asked how to start in normal mode, not in SUM. No one answered my question.

To elaborate the -m parameter starts sqlservr in SUM, I did restart, as after to restoring the master DB it prompts you to restart.

And to give a clear answer on how I got out of this situation, I reapplied SQL service pack 5. I had forgotten to do so after I began this install. I don't like typing a whole lot, so "starting over" was much quicker than going into detail.

If I am in the wrong, please say so and I will gladly award the points to whomever you chose fit. But if points are to be awarded, your were closer to the correct answer.
0
 
LVL 1

Expert Comment

by:Aycex
ID: 8194882
Actually I should have answered I thought he had the correct code but he was missing a paremeter so I would say no one gets them.  He put sqlservr.exe -m  and it should be sqlservr.exe -c -m, so I would say take them back and the more power to you he was wrong, and I should have looked closer and answered your question.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 8195434
Saving this Q as a PAQ and refunding the 20 points to the questionner

Thanks Aycex !

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question