Viewing 15 posts - 211 through 225 (of 991 total)
We're talking about table corruption here. The real crux of the matter was 'rebuilding indexes' being offered as a solution without demonstrating understanding of the problem. All caps and asterisks...
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
March 12, 2010 at 7:12 pm
A 2000 CHECKDB won't show problems because I didn't add all the data purity code until 2005.
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
March 12, 2010 at 3:48 pm
Dude - they're 2570 data purity errors. Rebuilding indexes is **NEVER** a solution for fixing corruption. You're wrong. Move on.
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
March 12, 2010 at 12:19 pm
And yet you recommended a solution with no idea what the problem is?
He(?) clearly stated its a data purity error - which finds invalid data for columns with data types...
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
March 12, 2010 at 8:05 am
ALZDBA - Can you explain what dropping adn recreating the indexes will do, apart from waste time and disk space?
djrgreene - you need to have a value that you can...
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
March 12, 2010 at 7:35 am
Good stuff Jason.
@medelstein From the (incredibly helpful, eh?) error, you're running the code on a SQL 2000 box, or in the context of a DB that set to the 8.0...
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
March 11, 2010 at 8:45 am
It won't do anything to help you. The reason why I got it to say what the minimum repair level is, is because that's what you'll need to run for...
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
March 10, 2010 at 10:32 am
Folks - this is another questions written by Kimberly - not sure why it's posted under my account instead of hers.
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
March 10, 2010 at 5:04 am
SharePoint's tricky, because allowing CHECKDB to delete some rows in the AllDocStreams table could mean you lose documents, potentially 'corrupting' the search database too and causing SharePoint failures.
You've got one...
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
March 9, 2010 at 10:23 am
Do you have any index maintenance that runs nightly, or is the data in the tables very volatile? I think you're seeing 'disappearing corruptions' - real corruptions but the pages...
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
March 8, 2010 at 9:30 am
Picking up the thread here, can you share some of the CHECKDB output please? Were the checksum failures re-appearing on the same databases? Are the databases stored on the same...
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
March 3, 2010 at 11:16 am
Can you run DBCC CHECKTABLE on sysobjects, sysindexes, syscolumns please?
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
March 3, 2010 at 9:20 am
GilaMonster (3/2/2010)
Paul, see 3rd post in this thread. (I can't tell if that's the full and complete output though)
Yes, saw that while reading the thread - and that's why I'm...
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
March 3, 2010 at 9:18 am
Either someone's messed with the system tables or there's more output from checkdb. Can you post the complete output of:
dbcc checkdb (yourdbname) with all_errormsgs, no_infomsgs
Thanks
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
March 2, 2010 at 5:29 pm
Don't do that. I strongly advise you to call Product Support who will stay with you on the phone while you sort this out - no disrespect, but with the...
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
February 28, 2010 at 10:09 am
Viewing 15 posts - 211 through 225 (of 991 total)