On Tuesday 31 March 2009 05:04:06 James Harper wrote:
> Am I correct in thinking that Bacula does not clear the archive bit in
> Windows once the backup has been done?

Bacula neither uses nor sets the archive bit on Windows.

>
> For MSSQL databases, I run a nightly MSSQL job that backs up the
> transaction logs to a file (different file each backup). MSSQL has an
> option to delete these after x days, but it almost always goes wrong at
> some point and stops deleting them.
>
> At clients who use Backup Exec, I use a scheduled .bat file that does
> something like: 'DEL /S /A-A *.TRN' in the backup directory which
> deletes all the transaction log backup files (*.trn) with their archive
> bit cleared, which Backup Exec had cleared after the file was
> successfully backed up.
>
> Bacula appears to not clear the archive bit and so this technique won't
> work anyway. Not that I'd be completely happy with it as a solution
> anyway as the archive bit would be cleared when the fd had processed the
> file, but because of spooling there is still the potential for the
> backed up file to never make it to the backup media, but it would be
> better than nothing...

Actually, I believe that the backup data is *guaranteed* to be on the Volume 
if the SD disconnects normally (i.e. no error) from the FD.  What has not 
been completed is putting the File Attribute data (metadata) in the DB 
catalog.

>
> Maybe a "Client Run After" script would be the solution?
>
> Any suggestions?

I recommend deleting the transaction logs on the next backup.  We could 
probably add a new plugin API call that would allow you to get the 
termination status of the prior backup.

Kern

>
> Thanks
>
> James
>
>
>
> ---------------------------------------------------------------------------
>--- _______________________________________________
> Bacula-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bacula-devel



------------------------------------------------------------------------------
_______________________________________________
Bacula-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to