Tagged Questions
2
votes
1answer
295 views
emergency-mode repair failed, nothing to do?
A production server got I/O disk error's I tried to fix it with dbcc but it got unexpected errors and crashed after a few minutes. so I took the file down and copied it over to a new machine.
I have ...
2
votes
2answers
186 views
Save Results of DBCC ShrinkFile
When we execute the following command:
DBCC SHRINKFILE('MyDB_log', 1)
We get the following results in SSMS:
DBID | Field | CurrentSize | MinimumSize | UsedPages | Estimated Pages
...
3
votes
1answer
345 views
DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS
I had to run dbcc checkdb repair_allow_data_loss with all_errormsgs and it's been runing over 27 hours. DB size is over 15gb and the server (windows 2008) has 32gb memory. I did run this on SQL 2005 ...
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
710 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) ...
2
votes
2answers
678 views
How does DBCC SHRINKFILE() affect backups?
I have a pile of SQL 2005 databases that have been around for a very long time and, for varying reasons, experienced transaction log autogrowth. Regular backups now keep the transaction log usage ...
2
votes
2answers
939 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 ...
8
votes
2answers
680 views
Possible to run two DBCC INDEXDEFRAG commands simultaneously, each on a different table?
I am currently running a script which performs a DBCC INDEXDEFRAG on every table in a SQL Server 2005 database, one table at a time. Using DBCC DBREINDEX instead of INDEXDEFRAG is not an option, due ...
