Viewing 15 posts - 286 through 300 (of 991 total)
I don't understand your question - rollbacks only occur when something goes wrong or you explicitly rollback a transaction - how could you calibrate them?
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, 2009 at 2:19 pm
Not necessarily - if something goes wrong the transaction will rollback automatically
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, 2009 at 1:55 pm
Here's the list off the top of my head of what will cause log reads:
1) transaction rollback (whether you explicitly start a transaction or do single-statement implicit transactions)
2) crash recovery
3)...
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, 2009 at 1:24 pm
On 2000 it will actually fix up incorrect PFS page free space bits silently, even if you don't say to do repairs. There was a bug in the algorithm 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
December 9, 2009 at 7:59 am
No problem - always enjoy this stuff.
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, 2009 at 9:55 pm
@jack-2 - Yup, although it's very dangerous to do so, in terms of availability, not corruption. I suspect they're on an earlier version though.
@kwoznica - No, no possibility of corruption...
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, 2009 at 12:38 pm
This is 2000 or earlier, right?
Looks like you're using a backup tool that is freezing I/O on the server to do its backups and hasn't thawed the I/O properly. This...
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, 2009 at 12:19 pm
The backup wouldn't change anything (it never does) but the shrink might have in such a way that the repair would work. 2000 is a bit dodgy as I said.
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
December 3, 2009 at 11:47 am
No, that's not possible either. The upgrade changes the database so 2000 can't understand it and bumps the version number from 539 to 610 or 611. Compat mode has nothing...
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 2, 2009 at 8:33 pm
How did the restore of the 2005 database to the 2000 server work? That's not possible at all. From the sequence of errors, it looks like the restore didn't actually...
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 2, 2009 at 7:53 pm
No problem Mindy - you could have just sent me email - I would have answered 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
November 30, 2009 at 7:40 pm
This is output from a 2000 server, right? FYI this is the 2005+ specific corruption forum. But I'll answer the question anway.
My guess is you have multiple CPUs and Enterprise...
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
November 30, 2009 at 7:20 pm
Gail - these are SQL 2000 corruptions (from the CHECKDB error messages). The rules for when a system table can be repaired are a little different between 2000 and 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
November 30, 2009 at 9:55 am
Hear, hear. As is, this article is terrible. You don't explain any of the reasons for doing this (or more importantly, not doing it).
You also say you must take 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
November 27, 2009 at 11:26 am
And this isn't a data corruption topic - please post in the appropriate forum. 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
November 24, 2009 at 8:29 am
Viewing 15 posts - 286 through 300 (of 991 total)