October 27, 2011 at 5:52 am
This is a strange one.
We have had to do a Bare Metal restore of a server which in turn prompted an uninstall/reinstall of the db engine. I have patched the database engine to the previous level and I can start SQL Server in multi-user mode. I now wish to restore the master db from backup.
I can't, however, start SQL Server in single-user mode.
The error log states:
Registry startup parameters:
-m F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
-e F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
-l F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
Server Error: 17113, Severity: 16, State: 1.
Server Error 3(error not found) occurred while opening file 'master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.
I am struggling to under stand how SQL Server will start in one mode, but not the other. Has anyone seen this before?
October 27, 2011 at 6:08 am
ggareth (10/27/2011)
Registry startup parameters:-m F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\master.mdf
-e F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG
-l F:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA\mastlog.ldf
Are these correct? Error 3 is folder not found iirc.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:16 am
Yes, these 3 parameters are correct.
To set single-user mode, do you know if I substitute -d for -m in the start-up parameter, or append -m; ?
October 27, 2011 at 6:20 am
I just noticed, with what you said, what's wrong.
-d is followed by the location of the master data file
-l by the location of the master log
-e by the location of the error log.
If all three of those parameters aren't there, SQL can't start up because it has no way of finding master's data and log.
Those 3 are the minimum. Other switches and traceflags can be added in addition to those three.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:24 am
OK, but to start SQL Server in single-user mode do I use the following as a start-up parameter?
-m;-d + Location of master data file;
-l + Location of master log file;
-e + Location of error log file
October 27, 2011 at 6:37 am
Starting from the command line or editing the startup parameters in service control manager?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2011 at 6:37 am
just start it from the commandline adding the -m parameter and you should be fine.
I haven't tried to add a fourth registry parameter with the -m .
(each entry can only contain a single parameter value)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 27, 2011 at 6:53 am
Thanks everyone. It was a classic EBKAC, I'm afraid. (Error Between Keyboard And Chair).
In the startup parameters of Config Manager, I was replacing -d with -m, rather than appending -m;.
I finally restored master from the command line, copied model to the correct location(!), and then restored msdb/model from the command line.
Just working my way through the user dbs.
Sorry to waste your time!
Phew.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply