MSSQL SERVER VERSION 10.0.4064.0

(0) Share

Report

Posted on by Kim Saffell

We receive the following error when running DBCC CHECKDB against the company Database.

CHECKDB found 2 allocation errors and 1 consistency errors in database 'SBM01'.

repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (SBM01).

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

We understand MSSQL needs to be in a single user mode. I have tried for hours, with internet onformation, to try to log into SQL in single user mode, and cannot.

It just hangs from the command prompt. Do we need to turn off firewalls, or Virus protectors. Please help, we need to run the repair script ASAP.

Thank you.

*This post is locked for comments

All responses (2)

Answers (1)

Kim Saffell 85 on at

Like (0)

Report

Re: MSSQL SERVER VERSION 10.0.4064.0

SUCCESS! Thanks so much!
Verified answer

Ian Grieve 22,782 on at

Like (0)

Report

Re: MSSQL SERVER VERSION 10.0.4064.0

In management studio type the following to switch SQL to single user mode (replace TWO with your database);

ALTER DATABASE [TWO]

SET SINGLE_USER WITH

ROLLBACK IMMEDIATE

GO

And the following to switch back to multi user mode (replace TWO with your database);

ALTER DATABASE [TWO] SET MULTI_USER

GO