CODEWITHSUNDEEP
sql-serversql-server-2005encryption
Brettski
Brettski

Reputation: 20101

Database file-level encryption

We recently were given a client requirement to encrypt all their data while at rest. They have agreed that encrypting the dbf, backup and trn files will suffice this need for them. My question is, do I need to encrypt the ldf file also? Is there any retrievable data in the ldf file that would require it to be encrypted?

Upvotes: 2

Views: 257

Answers (2)

Robin Day
Robin Day

Reputation: 102538

Anything that is written to the database is in the LDF.

Depending on your Recovery model depends how long this data will be there for.

It could be until you next perform a logfile backup.

Either way, yes, you should consider it to have as much valuable information in it as your database itself.

Upvotes: 4

John Sansom
John Sansom

Reputation: 41889

You can certainly read a SQL Server log file. All you need is a log analyzer of which there are many available on the internet.

You can even build your own.

Cheers, John

Upvotes: 3

Related Questions