EMS logo

Products Navigation

SQL Backup for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Backup for SQL Server

On-line Documentation

Backup Database


Backup Database step allows you to make a backup copy of one or several databases and transaction log.

 

To launch the backup job immediately select Quick_Maintenance_Actions Quick Maintenance Actions | iconServices_BackupDatabase Backup Database popup menu item at the Servers tab.

 

To perform scheduled backup on a regular basis you need to include this task into Policy:

1. At the Step 2 of the Create Policy wizard click Create new step button and select Backup Database step type.

2. Also, you can create a new Step Template for further use selecting Backup Database step type at the Templates tab.

 

Note: To restore a database from backup use Restore Database wizard.

 

Steps of the Backup Database wizard:

Naming step

Selecting database provider

Selecting database

Defining EMS SQL Backup settings

Setting backup options

Setting file options

Specifying cloud connections

Specifying backup verifying options

Performing operation

 

 


See also:

Backup database

Execute SQL Server Agent job

Execute T-SQL statement

History Cleanup

Database Integrity Check

Shrink Database

Reorganize Indices

Update Statistics

Database Parameters Logger

Maintenance Cleanup

Transaction Log Shipping

Database Shipping

Bulk Restore