Yes. BACKmeUP recommends using SQL Server Management Studio for Full or Differential backups of SQL databases. The SQL backups file(s) should be saved to a local folder on your server or another network location. BACKmeUP will backup the SQL Backup File daily. If you are not concerned about a transactional based SQL Backup with Logs, you can simply use the BACKmeUP Client to backup a SQL database (VSS is used in the background with SOS). Using BACKmeUP to backup an SQL database directly will only create a copy. The BACKmeUP Client will not truncate SQL Logs. To address the concern with the BACKmeUP Client running up a new backup of the SQL Database file daily: BACKmeUP will only backup the Delta to each SQL backup file. The same would apply when only using the BACKmeUP Client to backup the SQL database directly. BACKmeUP will backup the Delta changes only.
When there is a need to recover an SQL Database, you can simply use BACKmeUP to recover the applicable SQL Backup File reverting back to any date and time when a backup was run. After recovering the SQL Backup File from the BACKmeUP system, you can open the SQL Server Management Studio and recover the applicable SQL database. If you decided to only use the BACKmeUP Client to backup SQL, you would restore the copy of the SQL database from the BACKmeUP System, then replace and overwrite the existing SQL database.
Posted in: Technical FAQ's