SQL 6.5 single user mode

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
e-zlightAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SQLMonkeyCommented:
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
e-zlightAuthor Commented:
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
AycexCommented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

moduloCommented:
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
AycexCommented:
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
e-zlightAuthor Commented:
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
AycexCommented:
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
moduloCommented:
Saving this Q as a PAQ and refunding the 20 points to the questionner

Thanks Aycex !

modulo

Community Support Moderator
Experts Exchange
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.