Viewing 15 posts - 496 through 510 (of 991 total)
Cool!
I'd turn page checksums back on as soon as the broken page is no longer part of your table.
Don't worry about the drink - I had enough last night (unfortunately)...
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 24, 2009 at 7:01 am
Hmm - I'm concerned that CHECKDB couldn't repair the error. It's obviously a leaf-level page in the clustered index that's corrupt, but that should be a simple repair - deallocate...
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 23, 2009 at 10:28 am
Here's the blog post IAM page corruption examples. The 8946 doesn't crop up after all - that's for things like GAMs and SGAMs. I've zipped up the corrupt databases in...
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 22, 2009 at 8:14 am
Yeah - forgot to put a smiley in there 🙂
For a 2576 error, the only time the first IAM page ID will be NULL is when the code knows that...
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 22, 2009 at 7:11 am
Because I wrote the code. The NULL page Id is a special case.
It's also documented in MSDN as being the meaning in that special case - see http://msdn.microsoft.com/en-us/library/aa258785(SQL.80).aspx
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 22, 2009 at 4:54 am
Gail - in this case you're wrong.
These errors indicate that the first IAM page for an index does not have an entry in sysindexes. This commonly occurs when someone manually...
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 21, 2009 at 5:35 pm
Look in Books Online under 'LEFT' and it'll give you a link to the String Functions section.
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 19, 2009 at 2:45 pm
This isn't a data corruption question (which this forum is about) and looks like a homework question...
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 19, 2009 at 2:27 pm
See Kimberly's blog post 8 Steps to better Transaction Log throughput and my blogs
Search Engine Q&A #1: Running out of transaction log space and
Search Engine Q&A #23: My transaction...
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 18, 2009 at 7:59 am
ok, but this is an error caused by IO subsystems, not SQL Server. One of the IO subsystems involved had a problem that caused this. Can you run the following...
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, 2009 at 2:48 pm
You'll need to fix this before upgrading, using the method that gives you the smallest amount of downtime and data-loss (whichever is more important to you).
Did you have a power...
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, 2009 at 2:08 pm
No way should this be a make or break question IMHO.
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, 2009 at 1:19 pm
Krishna (3/8/2009)[hrBy the way How to vote on the blog? I am not able to find the way 😛
There's a survey widget-thing embedded in that blog post - is it...
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, 2009 at 7:24 am
It's part of the full-text system, but only in 2005 and before 🙂
I don't think it makes someone a bad DBA if they don't know it, but someone who does...
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, 2009 at 8:12 pm
ok - I blogged about this - go vote if you're interested: What's a valid question for a DBA interview?
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 8, 2009 at 6:45 pm
Viewing 15 posts - 496 through 510 (of 991 total)