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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 629
  • Last Modified:

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

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
chuck_aal
Asked:
chuck_aal
  • 4
  • 3
1 Solution
 
AycexCommented:
You don't have to use the command prompt, just reboot the server.
0
 
chuck_aalAuthor Commented:
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
 
AycexCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
chuck_aalAuthor Commented:
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
 
AycexCommented:
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
 
chuck_aalAuthor Commented:
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
 
AycexCommented:
No problem and again good luck!!!
0
 
conderscottCommented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now