For our MS SQL databases we have included a final step in the hourly
transaction log dump which triggers a NetBackup job that performs a
differential backup to a disk staged area on the backup server. The
staged area then gets backed up to tape every three hours. 

The transaction logs left on the SQL server get purged after 3 days.
Being a Windows based server the purging script checks to make sure that
the archive bit has been reset before doing the deletion.

-----Original Message-----
From: veritas-bu-bounces at mailman.eng.auburn.edu
[mailto:veritas-bu-bounces at mailman.eng.auburn.edu] On Behalf Of Deiter
Scott
Sent: Friday, 11 August 2006 6:08 am
To: veritas-bu at mailman.eng.auburn.edu
Subject: [Veritas-bu] Bparchive status

                                                SETUP:
Windows 2000 and 2003 clients
Netbackup 5.1 mp4
Solaris master/media
The bparchive is setup as a user backup and scripted in a dos.bat file.



                                 PROBLEM:
We have been forced to archive our sql tranasctions logs.
We have attempted to use the bparchive against a temporary directory
where we use robocopy to move the files from  source to this temporary
directory.  The ugly thing that just happened is that on of the files
was not completely there.  So a status 1 occurred.  None of the files
where deleted.  So next time(daily) we must create another image of
these files and hope for a status code 0. This consumes excessive tape
and time. 2-7 gig per day.

How can we use set up an archive so that every successfully archived
file is deleted at the end ?



Scott Deiter

_______________________________________________
Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


**********************************************************************
This electronic email and any files transmitted with it are intended 
solely for the use of the individual or entity to whom they are addressed. 

The views expressed in this message are those of the individual 
sender and may not necessarily reflect the views of the Christchurch
City Council.

If you are not the correct recipient of this email please advise the
sender and delete.

Christchurch City Council
http://www.ccc.govt.nz
**********************************************************************