Support

SQL Backup

SQL is an acronym of Structured Query Language which is designed for managing data in relational database management systems. Produced by Microsoft, the main function of Microsoft SQL Server includes insert data, query updates/deletes, create/modify schema, and data control access, etc. MS SQL 2000/2005/2008 are supported by EaseUS Todo Backup.

The extension of MS SQL backup image file is .bak.

User login

Click Other Backups > SQL backup in the menu. An authentication box will pop up. Input a valid Windows administrator or a SQL server account to get through the authentication. Don't forget to select the instance you want to login here.

Home

After authenticating, you will be presented with a SQL backup home page which includes a database list, a backup task list and some available options.

EaseUS Todo Backup SQL Backup

All the databases will be listed in the left panel. You can perform the operation you need after selecting one or more of them. Pressing the Disconnect button in the lower left corner will cut off the connection to the instance and take you back to the login window. Clicking Refresh will update the latest changes in the instance.

Backup

Unlike backing up normal data and Exchange data, you can set all related parameters in one step under the Backup page to back up the SQL databases. 

Basic information

EaseUS Todo Backup SQL Backup

Task name - Specify a name for the current task.
Destination - Specify the destination to save the image file. 
Continue if error - Decide whether to ignore media errors or not in the process.

Plan

All options under this section will be available after the Schedule is turned on. Then you can specify time in daily, weekly or monthly units and decide which type of plan to use.

EaseUS Todo Backup SQL Backup

Full - Always backup all databases and the transaction log.
Differential - Only backup changed files since last full backup. The transaction log will be included.
Transaction log - Backup transaction logs only.

Options

EaseUS Todo Backup SQL Backup

Compression - Decide whether compress the backup image file (this option is only available for MS SQL 2008 Enterprise and higher versions).
Notification - Decide whether send the backup result to email. For more information about this setting, you may refer to Email notification.

Recovery mode

Specify a recovery mode for the current task.

Simple - No log backups. Clear the log space automatically to keep space requirements small, essentially eliminating the need to manage the transaction log space. Putting a database into simple mode means that you don't want to make log backups and all you intend to do is rely on full backups for your recovery.
Full - Requires log backups. In this mode everything is fully logged so you can always recover individual transactions.
Bulk log - Requires log backups. It permits high-performance bulk copy operations and reduces log space usage by using minimal logging for most bulk operations.

Recovery

Please refer to the following steps to recover an MS SQL image file.

EaseUS Todo Backup SQL Backup

1. Switch to Recovery page.

2. Select the a database and specify an image to recover.

3. In the Select recovery mode, you can decide to overwrite the existing database or  recover to a new database by specifying a database name and location. Our product will automatically skip all media errors in the process if you check Continue If Error.

4. Click Proceed to implement the operation.

Export/Import

Export

Export a database as MDF and LDF files. Following are the detailed steps.
1. Select a database from the database list on the left hand.
2. Specify a location where to save the MDF and LDF files.
3. Click Proceed to implement the operation.

Import

Click Browse to import the MDF file. If you don't need the operation record of the database, just ignore the Browse behind the log file.

With the import feature, you can decide to overwrite the existing database or create a new database for importing MDF.

Log

All operations will be recorded in a log file. You can see what task was completed, when it was created, etc.

Tips:
Be careful when pressing the Clear button, because it will remove all information in the log file.