by Kevi » Wed, 11 Jul 2001 05:17:55
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.
by Keith Kratochvi » Wed, 11 Jul 2001 06:39:39
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.
by Brian Mora » Wed, 11 Jul 2001 06:44:05
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
7. Help : Sqlservr -c -f dun start in single user mode
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