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.
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.
> 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.