Re: Encrypt Database Files
Hi Helvi,
I'm not aware of anything that would stop Dynamics GP to work with an encrypted harddrive (though I've never tried it...). As long as the data is readable in a proper way by the SQL server instance, GP will be able to access the data.
I would more worry about the remote access to the data thru the network than the physical access of your hard-drives... I doubt that someone wants to break into your server room to steal your server's disks :-), unless you're running your GP off a system that is located below of your desktop in a cubicule...
Keep in mind that full data encryption may slow down the performance of your SQL server... SQL in GP is doing a lot of I/O operations when access the data. BTW, I've used to setup SQL 2008R2 databases on compressed drives (OS enabled) to save some disk space on test systems, and haven't noticed any notable performance issues, data compression should even improve it since there are less disk blocks to read from the plate... but again, this may not apply to encryption.