I have an SQL 2008 express database that when backed up produces a BAK
file of 44 Meg, zips to just under 4Meg.
When restoring the database on another machine the resulting mdf is 40
meg (good) and the ldf is 1.6 *Gb*!
Yes, i know I can shrink the ldf and also disable the LDF (SET RECOVERY
SIMPLE) but how on earth does it decide to create an LDF that is as
large as the original but clearly doesnt have the contents of the
original (unless I have unearthed the worlds most fantastic compression
secret)
Wal
