SQL Server Performance Forum – Threads Archive
sqlserver 2005 encrypted backups
in sqlserver 2005, is it possible to take encrypted backups?thanks,
Nothing inside SQL to encrypt and only way is to have password, the best approach is to encrypt the backup files as you create them. The products that will allow you to create encrypted backups with varying levels of encryption and encryption techniques.
Idera’s SQLsafe
Quest’s SQL LiteSpeed
Red-Gate’s SQL Backup
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Becareful if you are using the thirdparty tools to encrpt the backups because it may not as reliable as regular backups….
Why do you need to encrypt them when sql backups are not readable files? Don’t won’t be sufficient? MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
I don’t agree in case of Redgate’s SQLBackup, as it is one of the best tool available to accomplish such task. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
how about the
IDera SQL Safe backups?? is it reliable..
hi mohammed in this link
http://searchsecurity.techtarget.com/tip/0,289483,sid87_gci1229139,00.html they are saying that backup files are easily readable.
i am confused with this link with your statement that backups are not readable please let me know
Mohammed
SQL Backups are readable files, that means you can easily extract the content using another SQL instance. Priya
For more information on the usage of these tools refer to Software Spotlight section on this SSP website on homepage. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Yes, it can be read if you restore the db and you can read procedure code when you open in text editor and most of the data is non readable… I don’t remember I recently opened any of the backup files…but you can change the backup file attribute to Encrypt after backup completed… MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
Windows & SQL encrypt method is not that secure and using other tools you can simply decrypt, that is why third party tools comes handy here. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Have a look at HyperBac, which is a new solution for compressed, encrypted SQL Server backups which uses AES-256-bit certificate based encryption. HyperBac also allows you to integrate compression and encryption directly into your native processes without requiring the implementation of extended stored procedures or command substitution as the other solutions on the market do. Definitely worth checking out, www.hyperbac.com/sqlserver
]]>