?
Solved

SQL 6.5 single user mode

Posted on 2003-03-03
9
Medium Priority
?
249 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
9 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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

765 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