ADSM-L

Re: TDP for SQL Server Transaction Log Restores

2002-12-04 09:39:02
Subject: Re: TDP for SQL Server Transaction Log Restores
From: Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 4 Dec 2002 16:32:12 +0200
TDP docs say to set verd=reto=0. Just change them and go down the "restore
deleted file" road.

Zlatko Krastev
IT Consultant






"Seay, Paul" <seay_pd AT NAPTHEON DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
04.12.2002 16:17
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        TDP for SQL Server Transaction Log Restores


We have a requirement to restore the transaction logs back to their disk
location either on the orginal or an alternate server or to be able to
post
process the transaction logs as disk files some kind of way before they
get
deleted after a TDP for SQL Server Backup.

My DBAs tell me SQL server deletes the transaction logs immediately after
a
backup which presents a problem for a third party utility we want to do
auditing with.

Any ideas?

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180