Post reply

Database Encryption

  • July 30, 2008 at 9:45 pm

    #191868

    Hi Folks,

    Is there a process in SQL 2005 to encrypt a database fully so that authenticated users can decrypt the db. Please help!

  • July 30, 2008 at 9:52 pm

    #850979

    There is not. It's too much overhead to encrypt all data in there database by table. There are quite a few encryption options for columns.

    In SQL Server 2008, there is Transparent Data Encryption, which operates at the database file level, encrypting all the files, but it's mainly for lost media (physically).

  • July 30, 2008 at 11:32 pm

    #850993

    Thanks Steve.. am I right to say that you can encrypt the whole database in SQL 2000?

  • July 31, 2008 at 2:09 am

    #851056

    SQL 2000 has no built in forms of encryption. (well, not ones that are decryptable)

    SQL 2008 has transparency database encryption which protects the DB files on disk and the backups, but doesn't stop someone from connecting to the sQL instance and reading the data via a SQL query. They just can't take the DB files and attach them elsewhere.

    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

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

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