DBCC CHECKDB & Single User Mode

  • 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

  • Sorted it out !

    Use database_name

    GO

    ALTER DATABASE database_name SET SINGLE_USER

    GO

    DBCC CHECKDB('database_name', REPAIR_REBUILD)

    GO

    Thanks...Mike

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

  • Thank you for the update, greatly appreciated.

    Mike

     

  • Thanks to you both. This saved me from disaster.

    Rurik

  • repair_rebuild didn't fix any errors.

    what must be the next step?

  • 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