Post reply

What are the best options to secure backups without using third part tools ?

  • September 23, 2012 at 10:28 pm

    #262039

    Experts,

    What are the best options to secure backups without using third part tools ?

    I am able to think of the below options.

    Keep in disks/tapes at remote locations.

    Secure with password (I don't see this option in SSMS though :w00t: ).

    Anything else ?

    Thanks in advance.

  • September 23, 2012 at 10:52 pm

    #1541259

    Joy Smith San (9/23/2012)

    Experts,

    What are the best options to secure backups without using third part tools ?

    I am able to think of the below options.

    Keep in disks/tapes at remote locations.

    Secure with password (I don't see this option in SSMS though :w00t: ).

    Anything else ?

    Thanks in advance.

    Zip it with a password.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • September 24, 2012 at 12:56 am

    #1541279

    Thanks Jeff.

    Keeping at remote locations and securing with password are the only options ?

    Thanks again.

    San

  • September 24, 2012 at 4:04 am

    #1541322

    Upgrade to SQL 2008 and use TDE on the database (Enterprise edition only). Otherwise 3rd party tool of some form (backup tool, password protected archiver, etc)

    The password on SQL backups is not secure, books online does make that point.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 24, 2012 at 5:48 am

    #1541352

    Joy Smith San (9/24/2012)

    Thanks Jeff.

    Keeping at remote locations and securing with password are the only options ?

    Thanks again.

    San

    No. The only reason why I suggested what I did was because it's free, relatively easy, and offers good security. When you said that you wanted to avoid 3rd party tools, I suspected that the word "free" was an important factor.

    Like Gail said, you could use TDE but study the ramifications of that carefully before you do it.

    As she also said, securing it through an SQL Password isn't the right thing to do.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply