Post reply

DBCC CHECKDB & Single User Mode

  • May 17, 2006 at 5:17 am

    #168300

    Hi,

    I have ran the command DBCC CHECKDB ('database name', REPAIR_REBUILD) to correct 3 consistancy errors in a table.

    I have placed the server in single user-mode i.e.

    Stopped all SQL Services, from the CMD Prompt <directory name>\sqlservr.exe -c -m

    Went to Query Analyser to execute the command again and it tells me that it needs to be in single user-mode ! It is !!!!!

    Any ideas?

    Thanks.

    Mike

  • May 17, 2006 at 6:43 am

    #638392

    Sorted it out !

    Use database_name

    GO

    ALTER DATABASE database_name SET SINGLE_USER

    GO

    DBCC CHECKDB('database_name', REPAIR_REBUILD)

    GO

    Thanks...Mike

  • November 28, 2006 at 11:25 pm

    #674584

    Your database will remain in single-user modfe only.

    to return to multi-user mode:

    ALTER <database-name> SET MULTI_USER

     

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

  • November 29, 2006 at 2:46 am

    #674609

    Thank you for the update, greatly appreciated.

    Mike

     

  • July 9, 2008 at 3:43 pm

    #840545

    Thanks to you both. This saved me from disaster.

    Rurik

  • August 26, 2013 at 1:17 am

    #1644799

    repair_rebuild didn't fix any errors.

    what must be the next step?

  • August 26, 2013 at 1:28 am

    #1644803

    Benki Chendu (8/26/2013)

    repair_rebuild didn't fix any errors.

    what must be the next step?

    This thread is from a few years ago.

    Please start a new thread and post your error messages encountered by the CHECKDB and describe the actions yyou have taken sofar.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply