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.

Amelia

By Amelia / Updated on January 21, 2025

Share this: instagram reddit

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:

BACKUP DATABASE [YourDatabaseName]
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.

set the cobian backup

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.
Download FreewareMicrosoft SQL Server 2005-2022
Centralized and Secure SQL Backup

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.

add-device

Step 2. Click > Authentication to validate the database instance.

You can choose Windows Authentication or SQL Authentication. Enter the credentials and click Verify.

sql authentication

Step 3. Navigate to Backup Task > Create New Task, and choose Microsoft SQL Backup as the backup type. Then you can set:

microsoft-sql-backup

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

create differential backup of sql

Step 4. Click Start Backup to start the process. After the backup is finished, you can find it in the Backup Task tab.

start-backup

Step 5. Go to Backup Task, locate the task you want to restore, and click > Restore.

restore sql server differential backup

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.

Amelia
Amelia · Editor
Amelia is an editor from AOMEI. Trained in professional systems, she specializes in solving problems in enterprise databases, virtual machines, and physical environments. With a high sense of responsibility, she is dedicated to protecting business data and security.