Monday, September 30, 2013

Backup Tools to store data in the cloud, USB drives using SQL Server, MySQL and Oracle

Iperius Backup features are created to get the highest level of  performance and intuitive configuration. Iperius allows you to perform different backup types on many devices: NAS, RDX, LTO or DAT tapes, external USB drives, networked computers, FTP servers, Cloud storage services, such as Google Drive, Dropbox or SkyDrive. Iperius can backup SQL Server, MySQL and Oracle databases.

You can also make Drive Image backups, and create whole-disk images for Disaster Recovery and system bare metal restore with a few clicks. In addition you have many essential features such as e-mail notifications, detailed log files for each backup operation, execution of external processes and scripts, backup of open files (VSS), installation as service, synchronization, AES 256 bit encryption, Zip 64 compression, etc.

Iperius has also a free version, that can be installed even on Windows Server.
Iperius Backup can be downloaded from its official website:

Main features:

Disk backup / Network: this great software let you store your backups in NAS, external USB drives, RDX devices, computers in the network. Zip 64 compression, AES encryption, synchronization, and you can also have incremental backups.

Drive Image: You can copy all the information from an entire disk and automatically reinstall the system with some few clicks (bare metal restore). You do not need to reboot the system to create the disk image (hot backup), and you can restore in a different server with a different hardware.

Tape Backup: You can use any tape drive (LTO, DAT, etc.). Iperius backup compress your software and encrypts your data using AES encryption and includes automatic tape ejection. You can also restore files individually.

SQL Server, Oracle, MySQL: Iperius is a powerful and easy-to-use backup software for Oracle, MySQL and SQL Server. It can make automatic backups, it supports compression and encryption of backup files and copying of backup files to any destination.

FTP Backup and synchronization: You can  multiple FTP transfers, to and from unlimited servers. You can Upload and Download files zip them, encrypt them and limit the bandwidht.

Cloud Backup: You can easily send your backups to  Google Drive, SkyDrive or Dropbox,

Open file backup (VSS): Usually you cannot copy files because they are used by another process. However, with Iperius you have the Volume Shadow Copy functions. This feature allows you to do hot backups of Outlook files (.pst), virtual machines, mail databases, etc.

Highly configurable: It is a flexible and complete program, for backups. You can  filter and email notifications, transfer data and synchronize it.

Web Reporting: You can monitor the backups with a friendly and simple web interface.

I will now show how to do a simple backup using SQL Server and Iperius Backup to upload it to Google Drive or Dropbox.

In this example we are using SQL Server, but this great tool can work with MySQL, Oracle and growing.

Iperius Backup is a complete software for backing up SQL Server databases. Compatible with all editions of Microsoft database server: 2000, 2005, 2008 and 2012. With Iperius you can easily back up unlimited databases and servers, even remote, and run the restore in a really simple way, even creating a new databases. It has integrated .zip compression and encryption, backup verification and retention of multiple copies.

1. First we need to open the program

Figure 1
2. Press on user account icon and configure it with your SQL Server information (Windows or SQL authentication) and check if your connection is OK (Use Test connection button)

Figure 2
3. Then you can select if you will backup all your databases or select some of them.

Figure 3
4. You can select where you want to backup your databases (we will select the cloud option) and after that we will select the cloud service (dropbox)  
Write your login and password for dropbox

Figure 4

Figure 5
5. After you select what you will backup and the path, you  will also need to configure other options like schedule, email notification and other options

Figure 6

Figure 7

Figure 8

Figure 9

You can now run the backup manually, modify it.

Figure 10a

You will get a status when it is running and later you can restore when you need.

Figure 10

As you can see, Iperius is simple, fast, intuitive and supports multiple types of hardware, databases. It is definitively a great assistant for our daily database tasks.

0 comentarios:

Post a Comment