web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics RMS (Archived)

DBCC errors

(0) ShareShare
ReportReport
Posted on by

I am having dbcc errors on a RMS database. can you direct me to some scripts or ways to fix them>

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    Re: DBCC errors

    I have been trying to run the script DBCC CHECKDB (dbname, repair_REBUILD ) and I get an error that says the repair did not proceed. Database needs to be in single user mode.

    How do I get it into single user mode?.

  • Suggested answer
    Jeff @ Check Point Software Profile Picture
    13,382 on at
    Re: DBCC errors

    BACKUP FIRST!!

    SO/HQ Administrator

    Log in and open a new Query and type;

    ALTER DATABASE 'dbname'

    SET SINGLE_USER

    press F5 and close the query

    Open a new query and type;

    DBCC CHECKDB('dbname', REPAIR_ALLOW_DATA_LOSS)

    press F5 and close the query

    Open a new query and type;

    ALTER DATABASE

    SET MULTI_USER

    press F5 and close the query

    Any errors will be stored in a logfile C:\Program Files\Microsoft SQL Server\MSSQL\LOG folder

    Look in the Errorlog. file using Notepad or WordPad.

    BACKUP FIRST!!

    If you are a Partner or work for one, why are you asking questions of your Customers or potential ones instead of posting to the private Partner Forum;

    partnersupport.microsoft.com/.../mpndynrms

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans