> >
> > you could create a backup job with just that file in it and run it
> always
> > as full.
> >
> > - Thomas
> 
> I think his goal is to recreate some differential backups for MSSQL (RMAN
> provides it for Oracle).
> To do that, he needs to know which datafiles moved... If you perform a
> touch on each of them, it's not a differential backup but a full one.
> 

I am doing an incremental job, but Bacula doesn't know that the MSSQL database 
file has changed because the file size and datestamps don't get changed. The 
only way to do it is an MD5/SHA1 hash.

> Are we sure that all data pieces have been flushed to disk before the VSS
> snapshot occurred ?

I was, but it turns out I was wrong. In its current form the data is not 
flushed to the database file, only to the logfile it would seem. You need to do 
a CHECKPOINT on each database to flush properly.

James
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload 
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve 
application availability and disaster protection. Learn more about boosting 
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users