Viewing 11 posts - 1 through 11 (of 11 total)
The clustered index was already brand new with the pages shown, so no there shouldn't be a difference with a rebuild.
May 3, 2016 at 1:04 pm
There were errors in the mirror server Windows log, and I assume that it is a problem with the disk subsystem.
Event ID: 129
Reset to device, \Device\RaidPort3, was issued.
Event ID: 129
Reset...
May 5, 2014 at 2:22 pm
Thanks, it has been fun to check out Scott Hanselman's blog
January 14, 2014 at 2:38 pm
Thanks for your response. I will keep that in mind.
September 16, 2013 at 8:17 am
The company noticed some system updates needed to be installed. So they did that, and restarted the server. And now the CHECKDB error is gone, and I'm able...
October 26, 2012 at 3:12 pm
Thanks so much for your help. I'll take that approach.
October 26, 2012 at 9:43 am
No, nothing like that. The two lines are all that are printed to the screen.
October 26, 2012 at 9:31 am
That is really all that it returns when I run the command DBCC CHECKDB ('master') WITH NO_INFOMSGS, ALL_ERRORMSGS. I hope I am doing it correctly.
October 26, 2012 at 9:18 am
The result of
DBCC CHECKDB ('master') WITH NO_INFOMSGS, ALL_ERRORMSGS
is:
Msg 605, Level 12, State 3, Line 1
Attempt to fetch logical page (1:1115) in database 32767 failed. It belongs to allocation...
October 26, 2012 at 9:09 am
It doesn't look like they have a backup. They haven't had a DBA, so they are not following best practices in a lot of areas.
October 26, 2012 at 8:57 am
I'd have to ask them if an old backup is available to retrieve the sys.servers data, or any other corrupt pages. I've recently been brought it to do a...
October 26, 2012 at 8:53 am
Viewing 11 posts - 1 through 11 (of 11 total)