ADSM-L

[ADSM-L] Retrieving invalidated SQL transaction logs

2008-05-12 10:13:50
Subject: [ADSM-L] Retrieving invalidated SQL transaction logs
From: Rick Saylor <rsaylor AT AUSTINCC DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 12 May 2008 09:35:47 -0500
TDP client 5.2.1.0
MSSQL server 2000 sp4

One of our MSSQL servers started having array read errors last week
but the raid controller apparently didn't post the errors to the OS
or SQL. So, the backups happily continued but the data that was
backed up was corrupt. The backups done on May 6th are fine. However,
the backups done on the 7th, 8th, and 9th are unusable and it
invalidated the transaction logs because they were full backups. Is
there a way to retrieve invalidated transaction logs if they were
marked invalid/expired by the full backup process? Will marking the
bad full backups as invalidated let the older transaction logs show
up? Any help would be greatly appreciated.

Thanks,
Rick



----------------------------------------------------------------------------
Rick Saylor                  Austin Community College   Voice: (512)223-1182
Director of System Services  9101 Tuscany Way           Fax:   (512)223-1211
Information Technology       Austin, Texas  78754

<Prev in Thread] Current Thread [Next in Thread>