9/9/2023 0 Comments Download sql backup master keyThen I attached both with FOR ATTACH_REBUILD_LOG, set them to FULL recovery, changed the default auto-growth settings, and set the default location for log files in between (as this is the only way I know of to specify the location of the rebuilt log file): So, I downloaded the AdventureWorks2012 data file, made two copies, named them awSSD.mdf and awHDD.mdf, and placed one on the RAID 1 drive (D:\) and one on the SSD drive (E:\). I just wanted to test what kind of hit the different algorithms would take on full backups, from and to both traditional spinny disks (RAID 1) and solid state drives, and with and without native compression. I didn't want to get into comparing to 3rd party products – I'm sure they all do a fine job, and probably have additional features that I haven't even thought about. If you are currently using a 3rd party tool for encrypted backups, you should compare that to the functionality and performance of native encrypted backups. If you are currently using Transparent Data Encryption solely for the purpose of having encrypted data in your backup files, this could be a way to migrate from that technique and have encrypted backups without the hit that TDE places on your live system. This is something that 3rd party vendors have been offering for a long time, and it finally makes its way into the product, supporting four encryption algorithms: AES 128, AES 192, AES 256, and Triple DES (3DES). A new feature in SQL Server 2014 that many of you hadn't heard about until it was announced this week at the PASS Summit is native backup encryption in Standard, Business Intelligence and Enterprise Editions (sorry, Web and Express are not supported).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |