SQL Backup Saves Bandwidth and Time

Step 5:

Configuring Options for Compression and Encryption

SQL Server’s native backup utility doesn’t have the ability to compress or encrypt your backup, which would save resources and make your data more secure.

In SQL Backup, we can choose a compression level (standard, intermediate and moderate), and an encryption level (128-bit key or 256-bit key). The 256-bit key is new to this edition of SQL Backup. For more information on encryption see AES Algorithm of Rijndael.

Step 6:

Finishing Your Backup

In the last step, the wizard creates a script that you can run from Query Analyzer or the command line. You can also manage extended Stored procedures. If you configure the e-mail options, a notification will be sent when the operation is completed, which allows you to monitor your backups and restores easily.

Configuring E-mail

As you can see below, it is very easy to configure e-mail options — just provide the SMTP address, port number, username, password, etc. After a backup or restore is completed, a notification will be sent with the status — success or failure — of the operation. Configuring an e-mail notification is extremely useful for a DBA who also maintains remote databases.

A Sample E-mail

In this sample e-mail from a backup operation, the notification received provides the size of the database, the size of the compressed backup file, the compression rate, the time of the backup, etc.

Continues…

Pages: 1 2 3




Related Articles :

  • No Related Articles Found
Uncategorized

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |