Problem description
When we try to backup SQL DB files using the inSync client. Database file extensions are .mdf and .ldf
All files under this SQL directories showing as checked i.e. it should be backed up by inSync client.
Summary
inSync client was backing up the files with extensions .mdf and .ldf which are not used by the SQL server.
If we copy the actual DB file to another location or change the name of the DB files, it becomes a flat file which inSync can backup.
inSync client is not the correct way to backup SQL DB live files as they will be in use by the SQL Server.
Cause
inSync cannot backup live SQL Database files.
Resolution
To resolve this issue, need to use the Agent like Phoenix which can backup the Live SQL DB files.