Single User Mode

  • 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?

  • you might have named instanced installed .. try it..

    Abhijit - http://abhijitmore.wordpress.com

  • 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

    Sanz
  • Tried that Sanz - but get the same error.

    The instance is named - how do I start that instance in Single mode?

    Thanks

  • 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