Cobian Backup SQL Database with Detailed Steps
Cobian Backup is a third-party backup software, that supports file backups but you can use scripts to achieve SQL database backup. There is another third-party backup software, AOMEI Cyber Backup, for SQL database backup with an easier process.
An SQL Server database is a system for storing collections of tables, which organizes structured data sets in a tabular column row format similar to a spreadsheet. It can store important information about an individual or business inside, so backing up a SQL database is crucial if you want to keep your data safe. In this article, we provide you with two solutions to backup SQL database, Cobian backup SQL database and AOMEI Cyber Backup SQL database.
How to Backup SQL Server Database with Cobian Backup
Cobian Backup is a free backup tool that is typically used for file backups, but it can also be configured to backup SQL Server databases by utilizing its scheduling and scripting features. Here are the steps to Cobian backup SQL Server.
👉Prerequisite
Install Cobian Backup: Download and install Cobian Backup, it is available for both 32-bit and 64-bit systems.
SQL Server Instance is Running: Make sure the SQL Server instance to be backed up is running.
SQL Server Authentication Credentials: Access credentials of the SQL Server instance are required to perform the backup.
Step 1. Create a SQL Server Backup Script
If you want to use Cobian backup SQL database, you first need to write a SQL script that performs the backup, and then you can use Cobian Backup to execute the script, the following is a sample SQL Server backup script:
TO DISK = 'C:\Backups\YourDatabaseName_FullBackup.bak'
WITH INIT, COMPRESSION, STATS = 10;
Following are some explanations about the script:
- BACKUP DATABASE [YourDatabaseName]: Specifies the database you want to back up.
- TO DISK = 'C:\Backups\YourDatabaseName_FullBackup.bak': Specifies the path where the backup file will be stored.
- WITH INIT: Overwrites any existing backup files with the same name.
- COMPRESSION: Compresses the backup file to save space.
- STATS = 10: Displays progress information during the backup process.
Step 2. Configure Cobian Backup to Run SQL Scripts
Launch the Cobian Backup, click the Tasks menu on the main screen, and select New Task to create a new backup task.
Then you can set the Task Name and Backup type in the General tab.
Step 3. Test the Backup Process
After you run the backup task, you can check the output location of the backup, for example, C:\Backups\YourDatabaseName_FullBackup.bak, to ensure that the backup file was generated as expected.
An Easier and Efficient Way to Backup SQL Database
Since Cobian Backup does not directly support SQL Server backup, its backup process will be slightly complicated. Here we provide you with a simpler but backup solution - AOMEI Cyber Backup. It is a professional backup software that provides a convenient and error-free method of automatic full/incremental/differential backup of SQL server databases, while you can also enjoy other features:
- User-friendly Interface: The software has a clean and simple page layout that makes it easy to set up and manage backups.
- Automated Backup: Schedule VMware/Hyper-V VM backups and SQL Server backups to run automatically at a convenient time.
- Schedule Backup: It allows to creation of backup schedules to automate backups daily, weekly, and monthly.
- Operation within LAN: Assists you in making large backups of your SQL databases, including SQL Express on your LAN.
- Centralized Management: You can manage all your SQL backups from a centralized console, simplifying the task of managing and monitoring multiple databases or servers.
How to Backup and Restore SQL Server with AOMEI Cyber Backup
Prerequisite
Computer with both AOMEI Cyber Backup Agent and Microsoft Server installed.
Local disk or network share to store backup files.
Step 1. Navigate to Source Device > Add Microsoft SQL. If the database exists and the version is supported, it will appear automatically. Otherwise, you can click Add Microsoft SQL > Download proxy program and install the program on the device with SQL Server installed.
Then click Already installed proxy and select the proxies you want to add.
Step 2. Click … > Authentication to validate the database instance.
You can choose Windows Authentication or SQL Authentication. Enter the credentials and click Verify.
Step 3. Navigate to Backup Task > Create New Task, and choose Microsoft SQL Backup as the backup type. Then you can set:
- Device Name: specify the SQL instance and database for backup, you can select one or multiple databases you need.
- Target: to save backups, you can either specify a local path or a network path.
- Schedule: run the SQL database backup daily, weekly, or monthly, and set the backup method as full, incremental, or differential backup.
Step 4. Click Start Backup to start the process. After the backup is finished, you can find it in the Backup Task tab.
Step 5. Go to Backup Task, locate the task you want to restore, and click … > Restore.
Conclusion
Cobian Backup does not support SQL Server backups directly, but with scheduling and automation scripts, you can integrate SQL Server backups into your overall backup strategy to achieve a Cobian Backup SQL database. You can also choose to use AOMEI Cyber Backup for SQL database backup, which is a much simpler process, and it also supports virtual machine backup.