Viewing 15 posts - 406 through 420 (of 991 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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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)....
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 16, 2009 at 9:37 am
As background, someone manually changed the system tables on the database before you upgraded.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 15, 2009 at 3:47 pm
Yes.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 15, 2009 at 9:31 am
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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....
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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 -...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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...
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
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.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 14, 2009 at 5:33 pm
Dropping system table indexes - not in any documented way.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
May 14, 2009 at 5:19 pm
Viewing 15 posts - 406 through 420 (of 991 total)