Viewing 15 posts - 376 through 390 (of 994 total)
You can use the same hack to get a database attached in 2000 as you can in 2005 (create dummy database with same number of files and then shutdown and...
June 9, 2009 at 5:27 am
Is this a newly deployed/changed database, or is this a database that hasn't change and is suddenly seeing problems? Has the workload suddenly increased?
June 4, 2009 at 10:24 am
Chad - excellent. I'll be adding a link to this in all my DBA classes.
June 4, 2009 at 10:19 am
If that was the only error in the original CHECKDB output, then no, they weren't masked - as the catalog checks that produce that error are run after the checks...
June 2, 2009 at 5:29 pm
These are all record corruptions in nonclustered index ID 4. My guess is your IO subsystem is causing corruption, which was what corrupted the system table too.
You should be able...
June 2, 2009 at 5:16 pm
Hey Gail - I keep forgetting that trick you used last time too - cool if that works.
June 2, 2009 at 9:37 am
What were the suspicious error messages you spoke of previously?
You've got a few, equally unpleasant choices:
1) restore back to a backup from before the corruption occured
2) extract out the data...
June 2, 2009 at 8:38 am
Did there used to be another index? Was it dropped properly?
June 1, 2009 at 11:45 pm
@rlm - no, because OP didn't do that. He (from the name) changed the compatibility level of the database. You can't change the version of the database. They are not...
June 1, 2009 at 6:18 pm
Compatibility mode has nothing to do with the database version, just a few bits of query behavior.
Rebuild index 3 of table 1379588053. You can get the names using OBJECT_ID and...
June 1, 2009 at 5:24 pm
You can try that, but I think you'll end up hitting the same issue. Don't forget that after the upgrade you need to run DBCC UPDATEUSAGE once before starting your...
June 1, 2009 at 4:35 pm
Is this the first time you've run DBCC CHECKDB since upgrading to 2005? I'm guessing your answer is going to be no, as I believe this is a post-upgrade corruption....
June 1, 2009 at 4:05 pm
Shripad - start a new thread please.
Do you have backups you can restore from? You said you have - why don't you restore from them?
From what you've said, you have...
May 30, 2009 at 12:31 am
Why did that system restart?
Do all the drives have appropriate battery-backup on them to allow writes to be flushed before powering down? Even without write-caching, if a drive is in...
May 29, 2009 at 10:44 am
Viewing 15 posts - 376 through 390 (of 994 total)