Share
ReportI 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
You’re offline. This is a read only version of the page.
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
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;
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?.
#1
André Arnaud de Cal...
291,431
Super User 2024 Season 2
#2
Martin Dráb
230,503
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
