Viewing 15 posts - 406 through 420 (of 994 total)
No - don't add DBCC UPDATEUSAGE to your maintenance plan. It should be unnecessary. If you find that you're getting those errors from DBCC CHECKDB then its a *BUG* and...
May 18, 2009 at 5:19 pm
I didn't add the check until 2005 -all explained in BOL and the readme.
Only need to call PSS if it happens again.
May 18, 2009 at 1:59 pm
No - it's got nothing to do fragmentation.
On 2000, the row/page counts could become incorrect (and even negative) because of bugs in the algorithms to maintain them during heavy DML...
May 18, 2009 at 12:33 pm
Get your disk admins to check out the SQLIOSim tool which will simulate a very heavy IO workload and tell them when errors occur.
May 18, 2009 at 8:11 am
ok - for anyone else reading the resolution - that is NOT the supported/documented approach and is only suggested when EMERGENCY mode repair does not work (as in this case)....
May 16, 2009 at 9:37 am
As background, someone manually changed the system tables on the database before you upgraded.
May 15, 2009 at 4:07 pm
Repair could take a long time depending on what corruption has been found, and a host of other factors. See CHECKDB From Every Angle: How long will CHECKDB take to...
May 15, 2009 at 3:47 pm
There are at least two IAM pages that have been trashed, as well as some dedicated extents, which are causing a bunch of second-order errors to be reported. Be careful...
May 15, 2009 at 9:30 am
Glad you got it sorted with minimal data loss, and thanks for summarizing.
chkdsk - nothing to say the IO problems aren't transient, although it's strange that the errors have gone....
May 15, 2009 at 9:19 am
Very interesting discussion.
I'd say it depends. Ha ha. On what you're considering. I'm 37 this year. As far as coding is concerned, after 5 years owning the VMS file system...
May 15, 2009 at 9:11 am
Well all the errors look to be caused by the 6 pages that the IO subsystem trashed (the 6 8966 errors). This was definitely caused by the IO subsystem -...
May 14, 2009 at 9:59 pm
It depends on what backups you have. If your most recent backup is from last Sunday night, and you've done a bunch of work in the database since then, and...
May 14, 2009 at 6:52 pm
Yes, absolutely it can. Can you post what you tried to do and the error you received?
The only exception is if the database is in emergency mode.
May 14, 2009 at 5:33 pm
Dropping system table indexes - not in any documented way.
May 14, 2009 at 5:19 pm
Viewing 15 posts - 406 through 420 (of 994 total)