Home Forums SQL Server 2005 Administering What are the best options to secure backups without using third part tools ? RE: What are the best options to secure backups without using third part tools ?

  • 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)