>>> 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

Reply via email to