January 12, 2008 at 1:50 am
I am trying to start SQLServr.exe -m from the command prompt and here it say's.
C:\Program Files\Microsoft SQL Server\MSSQL\Binn>sqlservr.exe -m
2008-01-12 00:53:22.37 server Invalid command option C.
The file exist in the current folder and when i do a sqlservr /? switch, it lists all the parameters. unfortunately the above option doesnt work.
This is a production box and dont know,what else to try. Any help is greatly appreciated.
Many thanks,
Cali
January 12, 2008 at 9:48 pm
If it's in the current folder, run sqlservr.exe -m only.
January 13, 2008 at 12:48 am
I ran it from the current directory and it reports the same error. Dont know, why its behaving that. Is there any other way i could look into?
January 13, 2008 at 8:13 am
You are running from the "Binn" directory? Other commands work, like "dir"
What about just running "sqlservr"
January 13, 2008 at 11:52 am
DIR - CLS - DEL works from the Binn directory. anytime i run sqlservr.exe or sqlservr.exe -c -m or with any combo - none of them work. not even with sqlservr.exe. says the same error message. wonder what's going on.
January 13, 2008 at 12:41 pm
try net start mssqlserver -m instead
may need to use /m rather than -m
---------------------------------------------------------------------
January 13, 2008 at 1:54 pm
Gave it a shot. no luck. i wonder, if sqlservr.exe is corrupted or what. any different option i try, it gives the same path error.
January 13, 2008 at 8:31 pm
Is there anything ever written to the SQL Server error log or the Windows Event Log?
It's strange to see this type of error. I have no idea why you'd be getting this.
January 14, 2008 at 2:47 am
I see you are trying to start sql in single user mode, did you have a problem before causing the need to do this?
What happens if you try and start sql through the normal methods, i.e. services applet in control panel or sqlmangr?
does the account you are logged on with when you run sqlservr have enough rights to start sql via sqlserver?
---------------------------------------------------------------------
April 9, 2008 at 9:31 am
If you start from the command line (NET START), what does it say? Have you checked the Event log for errors.
Be sure that you have updated the startup parameters in the service to the correct new paths.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply