Cannot start SQL Server 7.0 in Single User Mode

• scottsanpedro

  SSCrazy

  Points: 2130

  More actions

  July 16, 2002 at 9:44 am

  #158432

  I have some corruption on a table and am wanting to run

  DCBB CheckTable ('MyTable',Repair_Allow_Data_Loss)

  but it must be in Single User Mode to allow this.

  I have tried to re-start the server using -m and also from Run Command sqlservr.exe -m

  The Dos box comes up and runs through quite a bit and stops therefore not re-starting the server. Also from Services with the -m is doesn't place it in single user mode.

  When i go to Query Analyzer it give the error, system must be in single user mode.

  Any help

  Thanks

  Scott

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  July 16, 2002 at 10:11 am

  #432807

  Scott,

  You need to set the database in single user mode, not the server. Per BOL...

  The database must be in single-user mode to use a repair option and can be one of the following.

  Right click on the database and select the options tab and select the Single User option. All should work well.

  Hope this helps.

  David

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  July 16, 2002 at 10:18 am

  #432808

  Don't forget you cannot put a database in single user mode while people are attached to it.

  Wes

• scottsanpedro

  SSCrazy

  Points: 2130

  More actions

  July 16, 2002 at 10:27 am

  #432812

  thank you....

  feel a bit of a dim wit now...

  was looking from the server point of view..

  thanks for your help, both of you..

  Scott