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

Subscribe to our news:
Partners
Testimonials
Paolo Benjamin T. Briones: "I just downloaded the trial and its great! IMHO, its a lot better than the Enterprise Manager from SQL Server".
Alex Torin: "Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".

More

Add your opinion

Customers
Download Buy

MS SQL Maestro online Help

Prev Return to chapter overview Next

Backup Database

The need to back up databases on a regular basis is a major component of managing any production system. To backup database means to make copies of data which may be used to restore the original after a data loss event. 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 full database backups, differential database backups, and transaction log backups. Use buttons on the top of the window to select the type of backup you want to perform on the specified database. The tool supports only Simple Recovery model.  To run this wizard select the Tools | Backup Database main menu item.

 

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



Prev Return to chapter overview Next