starting in single user mode

starting in single user mode

Post by Kevi » Wed, 11 Jul 2001 05:17:55



I am attempting to restore a set of backups of our
production databases to a test server.  I have started the
target server in single user mode / console mode
(sqlservr -m -c).  I am unable at this point to do
anything further, such as open a QA window to restore the
master database.

Once I can get the master db attached, I'll be fine.  Just
need to get over this hurdle.

Please do not refer me to BOF - I have searched BOF  
thoroughly and not found an answer.

 
 
 

starting in single user mode

Post by Keith Kratochvi » Wed, 11 Jul 2001 06:39:39


I have no choice except to refer you to Books Online.
Copy and paste this url into Internet Explorer:

This tells you how to start SQL Server from the command line
and how to restore the master database.

Do not try connecting from Enterprise Manager, as this app uses multiple
connections.  Also, do not try to start SQL Server Agent.  Start SQL Server
from the command line, open up Query Analyzer (or osql) and type in the
appropriate restore commands.  If you have problems with this, please post
any errors that you receive so that we will be able to troubleshoot.

--
Keith
==============
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.


Quote:> I am attempting to restore a set of backups of our
> production databases to a test server.  I have started the
> target server in single user mode / console mode
> (sqlservr -m -c).  I am unable at this point to do
> anything further, such as open a QA window to restore the
> master database.

> Once I can get the master db attached, I'll be fine.  Just
> need to get over this hurdle.

> Please do not refer me to BOF - I have searched BOF
> thoroughly and not found an answer.


 
 
 

starting in single user mode

Post by Brian Mora » Wed, 11 Jul 2001 06:44:05


what problem are you having?

In cases like this you need to remember that -M 'single user' REALLY means
single user...
* Enterprise Manager will eat the connection
* SQL Agent will eat the connection...

* make sure SQL Agent is stopped...
* make sure no other apps are using the server...
* don't use SEM at all... just start QA...

--

Brian Moran
CrossTier
SQL Server MVP
SQL Server Magazine Columnist


Quote:> I am attempting to restore a set of backups of our
> production databases to a test server.  I have started the
> target server in single user mode / console mode
> (sqlservr -m -c).  I am unable at this point to do
> anything further, such as open a QA window to restore the
> master database.

> Once I can get the master db attached, I'll be fine.  Just
> need to get over this hurdle.

> Please do not refer me to BOF - I have searched BOF
> thoroughly and not found an answer.

 
 
 

1. Remotely starting in single-user mode?

Hi All,

I was hoping someone would know of a way or utility to enable me to
start a remote server in single-user mode.

I am suffering from a documented bug of SQL Server's where the tempdb
log keeps getting expanded instead of the db. To remedy this, I
apparently need to start the server in single-user mode, then shrink it
and so on.

I would like to avoid having to sit at the machine itself, but I'm not
sure how to start a service with parameters (either through a DOS-style
window or the Services applet) remotely.

If anyone could give me a hint or some ideas, I'd be very appreciative.

Thanks,

Steven Bagshaw
CPA Online Officer
Australian Society of CPAs

2. US-NJ-APPLICATIONS SPECIALIST QAD

3. Won't start in single user mode

4. ADO Mickey Mouse: ADO and RDO handling of temp tables

5. Access Denied to SQL Server after starting in Single User Mode

6. serialize an object

7. Help : Sqlservr -c -f dun start in single user mode

8. View performance

9. Server always starts in single-user mode

10. sqlserver starting in single user mode

11. Sybase on linux - starts in single user mode

12. When Single User Mode is not Single User Mode