?
Solved

SQL2K - How do I exit "Single-User Mode"

Posted on 2003-03-25
8
Medium Priority
?
594 Views
Last Modified: 2008-02-01
Hello,

I needed to migrate the 'msdb' from ServerA to ServerB.
I put ServerB into single user mode using C:\......sqlservr.exe -m -c
I restored the 'msdb'
Now....How do I get ServerB back into Multi-User mode from a command prompt ?

Thanks in advance,
Chuck.

0
Comment
Question by:chuck_aal
[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
  • 4
  • 3
8 Comments
 
LVL 1

Accepted Solution

by:
Aycex earned 300 total points
ID: 8205086
You don't have to use the command prompt, just reboot the server.
0
 

Author Comment

by:chuck_aal
ID: 8205313
Thanks, that was easy enough.

A new problem has cropped up, now that I've restored msdb, I can't open MSSQL or SQL Server Agent.

I tried in 'Services' to start them also, but no luck.

The reason I restored msdb in the first place is to migrate the 'Jobs' over to the new server (we have over 100 of them) instead of re-creating them one-by-one.

It looks like in the process of doing so, I've done something that wont let me start the services successfully....

When it rains it pours......


Chuck.
0
 
LVL 1

Expert Comment

by:Aycex
ID: 8205344
Ouch.. I would definatly say you are correct it does seem to be pouring good luck finding the specifi issue causing this problem.  I have never had this problem so I am not sure what is wrong.  Did you also restore the master DB when you restored the msdb db that may be part of it???
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

Author Comment

by:chuck_aal
ID: 8205625
I only restored the msdb as (i think) that's the only one I needed to bring over the 'Jobs'

I'll try and restore the original 'msdb' over the copied one, and then if that works, I can look forward to a 'cut & paste' day tomorrow.

Thanks for your help.
Chuck.

0
 
LVL 1

Expert Comment

by:Aycex
ID: 8205718
Well seeing as there is no way you can break it worse try restoring the master first it may not recognize the difference and that is what is causing it not to start.
0
 

Author Comment

by:chuck_aal
ID: 8205893
That sounds like a good idea, if the restored msdb talks to the restored master, then maybe the services will decide to start.

Take Care & thanks.
Chuck.

0
 
LVL 1

Expert Comment

by:Aycex
ID: 8205953
No problem and again good luck!!!
0
 

Expert Comment

by:conderscott
ID: 20733901
I discovered that if you want to exit single-user mode without rebooting, you can select the command window running SQL and use Ctrl-C.  Then you can restart SQL Server normally.
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
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

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