Online Documentation for SQL Manager for SQL server

Backup a database

A database backup is created by means of the Backup Database Wizard. To launch it choose Services | Backup Database main menu item.

Using this wizard you can define the necessary backup parameters and options, such as the database for backup, backup type (Full, Differential or Transaction log), files of the database to backup, physical or logical devices, media options (append or overwrite media), data transfer and/or transaction log options and others.

You can also choose to create a backup now or create a schedule to run a database backup automatically.