>I'm upsizing a VFP database to SqlExpress2005.
>Dimensions, after loading data, are the following:
>- file.MDF 1 GB
>- file.LDF 3.7 GB
>
>I've two questions:
>1) the 4 GB limit of Express version applies to file.MDF or file.LDF?
>2) how to shrink the size of file.LDF? (2.1 - Is it a good idea shrinking file.LDF?)
>
>Thank you.
>Bruno

For your second question please see

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/do-not-truncate-your-ldf-files

8 Steps to better Transaction Log throughput
http://www.sqlskills.com/blogs/kimberly/post/8-Steps-to-better-Transaction-Log-throughput.aspx

Transaction Log VLFs - too many or too few?
http://www.sqlskills.com/BLOGS/KIMBERLY/post/Transaction-Log-VLFs-too-many-or-too-few.aspx