Viewing 15 posts - 556 through 570 (of 991 total)
Agreed - and I just replied to your thread on sqlteam.com with the same advice too.
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
January 19, 2009 at 9:16 am
Paresh Prajapati (1/17/2009)
Paul Randal (1/17/2009)
Paresh Prajapati (1/16/2009)
Tim Riley (1/8/2009)
I know there is, but I can't remember how...How do you go about restoring a database that has a corrupt/bad transaction log?
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
January 18, 2009 at 8:35 am
Paresh Prajapati (1/16/2009)
Tim Riley (1/8/2009)
I know there is, but I can't remember how...How do you go about restoring a database that has a corrupt/bad transaction log?
Please take a tail log...
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
January 17, 2009 at 2:42 pm
Fraid not.
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
January 15, 2009 at 1:08 pm
Just got back a couple of days ago.
The PK errors are because repair takes no account of any constraints when it does repairs - it's just making the database physically...
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
January 15, 2009 at 11:18 am
This is a case where you're not going to be able to get any further than restoring the first backup using CONTINUE_AFTER_ERROR. The log is damaged in such a 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
January 15, 2009 at 11:14 am
You've got corrupt pages in some of the critical system tables - this is why CHECKDB fails right away. These were most likely cause by the bad RAID controller you...
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
January 15, 2009 at 8:41 am
Hmm - haven't heard of this and it shouldn't happen. It can deadlock with user updates but then it should be chosen as the deadlock victim. I'd call Product Support...
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
December 15, 2008 at 1:16 pm
Hey George - I had a thought - can you try changing the setting of NUMERIC_ROUNDABORT and see if CHECKTABLE completes? If it does, you might be able to find...
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
December 14, 2008 at 8:42 pm
I'd try doing it in ranges, to limit the result set in each case. I'm not sure whether you'll get an indication of which row failde - at least with...
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
December 14, 2008 at 11:49 am
So it looks like you've got some corrupt data values in the table - can you select * all the data without any errors? My guess is that one or...
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
December 14, 2008 at 11:34 am
Try changing the setting of arithabort when you have quoted_identifier on... what happens?
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
December 14, 2008 at 11:20 am
I think its arithabort that's causing you problems - there's a section in Books Online called Session Settings That Affect Results - look in there. The problem isn't DBCC, its...
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
December 14, 2008 at 11:07 am
Right - you've got a computed column in the table and the SET options have to be on correctly for DBCC CHECKDB to run.
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
December 14, 2008 at 10:00 am
Probably this bug Corruption bug that people are hitting: Msg 8914 - PFS free space
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
December 12, 2008 at 11:30 am
Viewing 15 posts - 556 through 570 (of 991 total)