July 21, 2008 at 12:16 pm
Is anyone familiar with any tools that can detect corrupt TRN files before they are applied to a standby database ? We have a sittuation were we have the primary database which the users work off of and a off site standby database that is kept in recovery mode. The hourly TRN files are shipped to and applied to the standby database, we had a situation this week where a corrupt TRN file was applied to the standby database thus corrupting all the databases and making them unusable.
We are looking for a tool that can scan the TRN file before it is applied to the standby database.
July 21, 2008 at 12:32 pm
There is no tool that can detect whether a transaction log backup contains log records that include corrupt data (e.g. an update of an already corrupt value). There are methods to detect whether the backup itself is corrupt - use WITH CHECKSUM when the backup is taken and then check the integrity of the backup using RESTORE ... WITH VERIFYONLY.
Check this out for some more details - http://www.sqlskills.com/blogs/paul/2007/09/04/Example20002005CorruptDatabasesAndSomeMoreInfoOnBackupRestorePageChecksumsAndIOErrors.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
July 21, 2008 at 12:44 pm
Thanks for the quick reply.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply