>>> Is there a way to force the backup of specific unchanged files during > an >>> incremental or differential backup? Eg: >>> >>> Option { >>> File = "C:/database/mydb.mdf" >>> Always Back Up = Yes >>> } >>> >> >> 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).
you can't do a Differential or Incremental backup of MSSQL data files. this would require a FD plugin or another tool. > 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. > > Are we sure that all data pieces have been flushed to disk before the VSS > snapshot occurred ? yes, MSSQL provides a VSS "Plugin". so MSSQL knows when it has to flush to disk. - Thomas ------------------------------------------------------------------------------ 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