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

Comments are closed.

BACKmeUP provides and is BACKED by the industry’s best online backup solution for Personal and Business Users. BACKmeUP’s online Backup technology solution provides continuous data protection for thousands of Home & Business users world-wide. Our Backup Software is loaded with state of art backup features like remote data access, unlimited versioning & data archiving, powerful data recovery to protect your data24/7. Whatever your data, whether its digital music, photos or video or business databases or application data, Start backing up with BACKmeUP today!

* About Us     *Terms and Conditions     *Regulatory Compliance, Privacy & SLA Information      *Refund Policies
BACKmeUP© Copyright2010
Provided by BAYETE TECHNOLOGY