in
Support Center
StorageCraft Support Center » ShadowProtect » Server Edition » SQL and Bitlocker

SQL and Bitlocker

Last post 03-06-2010 5:58 PM by yessams. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 03-05-2010 7:17 AM

    • Niko
    • Top 500 Contributor
    • Joined on 03-05-2010
    • Sweden
    • Posts 10

    SQL and Bitlocker

    Reply Contact
    Hello How questions about server editon How does it work when you backup a sql server, will it empty the transaction logs or must you put the databases in simple recovery mode? How does it do when it comes to bitlocker, backup, restore? Best regards, Niko

  • 03-06-2010 5:58 PM In reply to

    Re: SQL and Bitlocker

    Reply Contact

    I am not as familiar with bitlocker...is this encryption software.

     

    For SQL Server 2005 and up (because they are VSS aware) I remove all maintenance plans and place the database in simple recovery mode (to keep the incremental snap file size smaller).

     

    This quieses the databases which in turn makes the MDB files pristine. On all of the backups I enable the encryption password.  I have performed numerous numerous restores, mostly tests, but some based on need of the MDB files, and each time the database has been able to be attached without corruption or any issue.

     

     

    Hope this helps.  Good Luck!

     

    S

Page 1 of 1 (2 items)
© StorageCraft Technology Corporation 2009