Skip to main content
inSync Client cannot backup SQL DB files
Updated over a week ago

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

  1. inSync client was backing up the files with extensions .mdf and .ldf which are not used by the SQL server.

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

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

Did this answer your question?