MS SQL does not backup modified files

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b7db6744-cd7b-42b5-a84e-5e511a5e8e59/mdf-ldf-files-last-modified-date-not-increasing-as-expected?forum=sqldisasterrecovery

Duplicati fails to backup modified ldf and mdf files because its timestamp does not change. (see link above)

what parameter can be used to ignore timestamp and size.

You can use --disable-filetime-check to do this.

1 Like

This was it. Thanks,

one more, what if the database file size is say was 1Gb at first successful backup now with dfc enabled the timestamp is not checked. but when its time for the next scheduled backup even though the file is modified its size still remains 1Gb, no change in file size. Will the file now get backup.

Yes, the option disables the check for whatever version was there before and just scans the file.

1 Like