Tagged Questions
5
votes
2answers
272 views
SQL Server 2005 database corruption. Advise
I have encounter some database corruptions in the past but I knew which object has hit the road. In this situation I run a DBCC CHECKDB against a problematic SQL Server 2005 database and I get the ...
1
vote
1answer
3k views
How do I fix this corrupted page?
My database is in simple recovery mode. One page got corrupted and I only have backups created using simple backup.
When I run this:
DBCC PAGE ('myDB', 1, 952663, 3)
I get:
DBCC PAGE error: ...
12
votes
1answer
711 views
What types of corruption can DBCC CheckDB miss?
This question was prompted by this earlier post and my having a database filed away for future investigation that was restored following:
BACKUP 'BrokenDatabase' detected an error on page (1:123456) ...
4
votes
4answers
25k views
SQL Server 2008 R2 (Suspect) mode - how to repair?
I have SQL Server 2008 R2 database in Suspect mode. I tried to fix it running this query:
EXEC sp_resetstatus ‘yourDBname’;
ALTER DATABASE yourDBname SET EMERGENCY
DBCC checkdb(’yourDBname’)
ALTER ...
2
votes
2answers
941 views
An inconsistency was detected
Am running asp.net application.Am searching records.if i click the view button i got this error,
an inconsistency was detected during an internal operation in
database(database name) on ...
