Viewing 15 posts - 571 through 585 (of 991 total)
-- Cranfield (12/12/2008)
btw - I was at your Surviving Corruption session at PASS. It was the best session I attended. As you can see...
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 9:58 am
Most of the frontline support folks know less than many people here...
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 9:38 am
Steve Jones - Editor (12/10/2008)
You might want to call MS support and work through this, checking to see if you might have hardware issues.
Not much point - they're not going...
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 11, 2008 at 7:57 am
Repairing here would have lost two pages of table data - but I might still have been tempted to restore the backups and see if those two pages were 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
December 9, 2008 at 1:55 pm
As Gail said, use RESTORE WITH STOPAT to recover your database to the point before the corruption occured (roughly as follows)
1) Restore the full database backup. Use the STOPAT 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
December 6, 2008 at 9:07 am
No - because of condition (b) that you specified. If the database is switched to FULL recovery model, but a database backup isn't done, then the database stays in a...
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 5, 2008 at 2:06 pm
Mazharuddin Ehsan (12/4/2008)
Paul Randal 12/4/2008 10:50 AM
-------------------------------------------------------------------
It's not a B-tree (either the classic B-tree, or 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
December 4, 2008 at 2:07 pm
Not my area of expertise - someone else on the thread will help out I'm sure.
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 4, 2008 at 9:08 am
Mazharuddin Ehsan (12/4/2008)
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 4, 2008 at 7:05 am
johan.kitti (12/4/2008)
You can't attach a SQLsrv2005 DB File on a SQLsrv2000.
And what Johan meant was that the original error you got was nothing to do with the database being corrupt,...
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 4, 2008 at 6:55 am
The *only* way to fix this in the current database is to go in and hack the system tables using the procedure I've documented.
You could migrate to a new database...
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 4, 2008 at 6:52 am
First off, please post in complete words rather than text-message jargon - it makes posts much easier to read.
Your I/O subsystem has issues - plain and simple. The first error...
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 3, 2008 at 7:04 pm
A PHYSICAL_ONLY check will check the integrity of the allocation bitmaps and then read every allocated page in the database and do a page audit. It skips all inter-page checks....
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 3, 2008 at 1:44 pm
If you run a full DBCC CHECKDB you'll see a *lot* more corruption errors as a result of the errors you've already posted.
You've got some interesting corruption in one of...
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 3, 2008 at 10:05 am
Not off the top of my head - Google 'sql kb index rebuild corruption' and you'll get some links.
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 3, 2008 at 7:05 am
Viewing 15 posts - 571 through 585 (of 991 total)