Protect your MySQL, PostgreSQL, MariaDB and Microsoft SQL databases with full and transaction log backups.
There are numerous types of DBMS, and we have specific modules for each.
Essential tips for Database Backups: Microsoft SQL Server, MySQL, MariaDB, and PostgreSQL
Database backups are essential for ensuring data recovery and facilitating migration processes. Although SQL databases use a common language, the tools and methods for backing them up can differ significantly.
The most important feature of any SQL backup system is that it must back up live databases and maintain 24/7 operations.
Our software has free inbuilt modules for backing up and restoring MySQL, PostgreSQL, SQL Server, and MariaDB databases.
Why is it crucial to back up SQL with a module?
Data Recovery: SQL backups enable the restoration of a database to a specific point in time following a system outage.
Data Migration: SQL backups can assist data transfer between different systems.
Can I copy the source database files underneath?
Directly copying database files can lead to corruption, and will almost certainly require the database to be taken offline when working with non-Windows systems that can’t utilise VSS. Databases maintain internal structures like indexes and transaction logs that may not be consistent across copies.
Best practices for backing up SQL databases
Storage Locations: Maintain at least two backup copies, locally and off-site, such as in cloud storage.
Automation: Schedule regular backups to ensure continuous data protection.
Encryption: Encrypt backups to safeguard sensitive data from unauthorised access.
Testing: Regularly test the backup restoration process to confirm its effectiveness.
Useful links
SQL versions we back up – https://www.bobcloud.net/version/
Price calculator – https://www.bobcloud.net/calculator/
Contact a specialist – https://control.bobcloud.net/submitticket.php?step=2&deptid=2
BOBcloud’s cloud-to-cloud Microsoft 365 backup removes all risk of you losing data from the Microsoft cloud. With our backup suite, you can always restore your Exchange email, SharePoint Sites, OneDrive data, and Microsoft Teams.
Choose from hundreds of storage locations worldwide, and mirror your backed-up data to multiple destinations.
BOBcloud’s M365 backup solution is simple, secure, easy to use and configured in minutes.
We only use ISO 27001 and SOC 2 accredited storage with the world’s most popular clouds, such as Microsoft, AWS, and Wasabi.
Restore any M365 entity from single Exchange emails to SharePoint sites and OneDrive files granularly.
Enjoy unlimited retention and history on all your data.
PAYG model with no contract or tie-ins.
Stellar data security: We encrypt your data chain end-to-end during backup, transfer, rest and restore. Even if someone were to capture your data packets during transfer, they couldn’t decrypt the data in your cloud storage.
GDPR compliant: GDPR is always paramount in our methodologies, so we never routinely capture personal data.
25+ years in business: Since 1999, we’ve provided reliable and secure Microsoft backup solutions.
7-Day Support in your region.
If you are deciding on a new cloud storage partner, we can ease the transition with £250 credit
Store unlimited revisions of your data to multiple online and local locations. You choose your level of durability
Our team are always on hand to provide quick 7-day-a-week support. We have a knowledge base and a forum
Our M365 backup suite allows you to manage and back up thousands of accounts using a single admin screen. Monitor all the license, storage, backup and restore stats from one place.
Yes. If the source SQL files aren’t locked, you can back them up or take a local copy, which can then be backed up.
The recommended SQL backup method is to use one of our SQL modules, which are built specifically to back up each version of SQL. These modules are free within the base license.
Yes. Our backup software can slipstream the database to a backup. The restore method can be complete or transactional, using the logs if you are restoring only recent changes.
All databases contain massive amounts of white space that is removed during the compression stage of a backup.
When backing up using one of our SQL modules, we expect up to 90% compression ratios on databases.