SQL Encrypted Database

Posted on 2012-09-18
Last Modified: 2012-09-21
We need some third party software that can compress an encrypted SQL Database.

We are using SQL 2008 R2 but you can not use its built in compression on an encrypted database therefore we are in desperate need of a third party app that can facilitate this.

Any help will be appreciated.
Question by:Kyle_Davies
    LVL 9

    Accepted Solution

    LVL 5

    Assisted Solution

    LVL 16

    Assisted Solution

    You could use Robo-FTP to do it, a couple different ways actually.

    Here is a sample script that creates and sends SQL transaction log backups (in order of oldest to newest if multiple files exist) over an SSL encrypted FTP session with inline compression:

    You could modify it to do zip with a password for simple encryption or you could make it do hardcore encryption with PGP.  The PGP has built-in compression but I suppose you could zip on top of that if you really wanted.

    Here is a server-side script for Robo-FTP Server.  It can receive the backup file and restore it to an offsite copy of your database:  Since all of your backups are actually being restored somewhere else you are also testing the backups themselves... to help prevent the situation where you go to restore something from backup and only then discover that your backup is no good.

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    SQL Query 18 66
    indexed table vs unindexed table 19 51
    query question 4 20
    Best free SSMS add-in for Microsoft SQL 2014 20 0
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now