Backup secirity

  • I have backups that are done remotely, and would like to ensire that they are secure. How can i go about this?

    And are there any free softwares that can do this?

    Please help

  • Depends on what you mean by "secure". Do they need to be encrypted? Does their transmission over the network need to be? Is the network you are backing up over a LAN or WAN or the internet?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • kerusy (3/9/2009)


    I have backups that are done remotely, and would like to ensire that they are secure. How can i go about this?

    And are there any free softwares that can do this?

    Please help

    Yes, it depends on what level of security you are talking about? At the least you can make sure to restrict users to the backed up files, encrypt them and protect them with a password.

  • It needs to be encrypted, the network too, and its being transferred over a WAN

  • It needs to be encrypted, the network too, and its being transferred over a WAN

  • If you haven't already and it is within your budget, you might consider upgrading to SQL Server 2008 Enterprise Edition. This version has a feature called Transparent Data Encryption (TDE). This feature encrypts the physical files of the database including the transaction logs. When the data is backed up it is already encrypted and should provide the protection you are looking for.

    Please note that this does not encrypt the data itself, it is intended to protect the physical files.

  • For Offshore backups to be secure on the wire, you should think about VPN connection. That would make that part secure.

    As previous poster said, there is Encryption possibility in SQL 2008.

    -Roy

  • for exchange/file backups we run Seagate Evault Infostage. it's similar to Netbackup or Commvault but the data is on disk. it runs on top of any x86 server and you can use any disk. the data is encrypted over the wire and on disk.

    they also have a nice replication feature since the engine is sql 2005 express edition.

    you backup to a local vault and it replicates everything to a remote vault. if your local vault crashes and you lose all your backups then, everything is backed up to the remote vault. you rebuild your local vault from scratch and replicate the data back

    we looked at this for our SQL backups, but the disk will cost a fortune. even with SATA drives.

    all LTO-4 tape drives have hardware encryption built in, but i'm not sure if the data is encrypted over the wire. netbackup might do it

Viewing 8 posts - 1 through 7 (of 7 total)

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