> > > > 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users