Encrypt the location of my database files?

[bryallan]

Hi,

I am running outlook with BCM on a single laptop, no sharing. I travel
with my laptop and would like to keep my client's information
confidential should something happen to my laptop.

I would like to change the folder location of the BCM database files
to an encrypted partition on my hard drive. I am using truecrypt to
encrypt that partition.

I have microsoft sql server management studio express.

Any ideas?

 

[Luther]

Hi,

I am running outlook with BCM on a single laptop, no sharing. I travel
with my laptop and would like to keep my client's information
confidential should something happen to my laptop.

I would like to change the folder location of the BCM database files
to an encrypted partition on my hard drive. I am using truecrypt to
encrypt that partition.

I have microsoft sql server management studio express.

Any ideas?

BCM has a default folder in which it creates new databases, but once
the database is created, BCM just accesses the database through sql
server connections and doesn't care where the database is actually
located.

The trick in your case is to get sql server to look for the database
files in a folder on your encrypted partition. I don't know if sql
works well with encrypted partitions. It should work if the encryption
is implemented as a driver, but encryption always adds some
performance overhead. You can read the Sql documentation or ask the
sql server newsgroup how to move database files to another folder.

Another solution is to have sql use encrypt databases. I believe
that's a feature of Sql 2005.