Yes, potentially.

You'd have to do the following:

- extract all inserts performed after the table was emptied

- restore the database to time just before the corruption occurred

- manually merge in the...

The vast majority is the I/O subsystem (software or hardware), small percentage is bad memory or other server issue, and small percentage is SQL Server software bugs.

Corruption can't be prevented,...

Hey Jeff - nothing explicit, but that's going to be the topic of my next article for SSC that I'll be writing this month.

@jim - exactly!

@adam-2 - indeed, using WITH TABELRESULTS is the way to go.

Hey Daniel - no, your thinking isn't right. Remember that DBCC CHECKDB isn't a checksum-checker, it happens to check checksums as part of what it does, but it goes a...

dharmendra.keshari (11/8/2012)

---

Hi Paul,

Thank you so much for writing on CheckSum. it is really awesome blog.

Could you please provide any link which gives us information about the all the activities...

Michael Meierruth (11/8/2012)

---

After reading your recent 'Importance of Validating Backups' and now this article on DBCC CHECKSUM, I'm very curious to know how much database corruption is really encountered in...

distas (10/25/2012)

---

Gila, thank you for your constrictive criticism. Unfortunately, the rest of the comments made by other participants were just useless buzz, worse than they claimed my article to be....

No matter what size or options you specify, shrinking a log file can only ever remove inactive VLFs, and only from the end of the file.

My goodness - what a load of utter nonsense in this article.

You must be corrupting a page that is not allocated - you need to figure out which page you're corrupting and then check it's allocation status using DBCC PAGE.

For the...

It's nothing to do with DBCC - it's the try/catch eating the errors being printed. No idea how to use that correctly - it has some weird behavior.

Nothing changes the...

Too many ambiguities in your post and question. For instance, the 'end' of what? Page? Database? Backup file?

Can you give the exact set of steps and T-SQL, from creating the...

Or to automate restoring master on a scratch server and running DBCC CHECKDB on it.

It won't work because there are some structures that only exist in the master database and may cause corruption errors to be reported if master is restored as a user...