January 21, 2011 at 7:28 am
Hi there,
I am trying to start my SQL SERVER 2000 in Single User Mode in order to restore master, model, msdb.
I am running sqlservr -m and getting the following error -
SQL Server could not find the default instance (MSSQLSERVER) - please specify the name of an exsisting instance on the invocaion of sqlservr.exe
I only have one instance of the programe located at
C:\Program Files\Microsoft SQL Server\MSSQL$OUTSMARTLIVE\Binn
Any ideas what is going wrong?
January 21, 2011 at 7:48 am
you might have named instanced installed .. try it..
Abhijit - http://abhijitmore.wordpress.com
January 21, 2011 at 8:01 am
To start the default instance of SQL Server in single-user mode from a command prompt
From a command prompt, enter:
sqlservr.exe -c -m
Note:You must switch to the appropriate directory in the command window before starting sqlservr.exe.
Reference : http://msdn.microsoft.com/en-us/library/aa178018(v=sql.80).aspx
January 21, 2011 at 8:30 am
Tried that Sanz - but get the same error.
The instance is named - how do I start that instance in Single mode?
Thanks
January 21, 2011 at 8:40 am
sqlservr.exe -m -s OUTSMARTLIVE
---------------------------------------------------------------------
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply