News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) MSSQL SERVER VERSION 1...

Microsoft Dynamics GP (Archived)

MSSQL SERVER VERSION 10.0.4064.0

(0) Share

Report

Report

Posted on by Kim Saffell

85

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 Img

All responses (2)

Answers Img

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans