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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
