Re: [ADSM-L] Retrieving invalidated SQL transaction logs

Del,

Thanks for the quick response, but I'm actually referring to the logs
that get invalidated when a full backup occurs. What my DBAs are
trying to do, since the full backups on the 7th, 8th an 9th are no
good, is get all of the logs after the May 6th backup. However, these
logs are marked as inactive on the GUI but we don't see them when
using the command line. The hope is to restore the May 6th backup and
apply all the inactive logs to the database.

Thanks,
Rick

At 10:03 AM 5/12/2008, you wrote:

Rick,

I think you mean "expired" transaction log backups, not invalidated.
As long as the management class for the log backups retains
expired log backups, they will still be there and they will
be restored when you need to restore the full backup that they
are built on top of.

You can see if they are still there.. by using the GUI
and clicking the "Show Active and Inactive" checkbox,
then choosing the database on the left that you are interested in.

... or using the CLI by entering this command;

     tdpsqlc query tsm * /all


Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 05/12/2008
10:35:47 AM:


> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> 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