I have a SQL Server Express 2008 instance of which I am attaching databases from development systems quite often. Typically I transfer the
.LDF files to the instance's
DATA folder and reattach, and everything is fine. In the past when we used Access instead of SQL Server Express, I would keep the database file on a separate drive (SSD) which tended to increase performance, as well as let me use BitLocker drive encryption on the whole SSD for easy encryption and whole drive backups. I would like to do the same with SQL Server Express.
Can I put the
.ldf files on a separate drive (not in the instances
DATA folder) without any ill effects? Do I need to change settings through the Management Studio to do this? Can I still use BitLocker Encryption?
Thanks very much!