Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

MS SQL Maestro online Help

Prev  Return to chapter overview Next 

Backup Database

The backup and restore components of Microsoft SQL Server allow you to create a copy of a database. This copy (called backup) is stored in a location protected from the potential failures of the server running the instance of SQL Server. If the server running the instance of SQL Server fails, or if the database is somehow damaged, the backup copy can be used to recreate, or restore, the database. As is well known implementing a well-planned backup and restore strategy protects databases against data loss due to damage caused by a variety of failures.

 

Backup Database tool allows you create the various types of data and differential backups. Use buttons on the top of the window to select the type of backup you want to perform on the specified database.

 

To find some explanation for the tools's parts and their elements, use Backup options.

 



Prev  Return to chapter overview Next