Announcements
No record found.
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 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?.
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)
ALTER DATABASE
SET MULTI_USER
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.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.