Please comment on the db file sizes. Why do I have such a big K2_log.LDF? Is the DBA not backing up the transaction log? Every night we are supposed to do a backup, and that should empty out the K2_log content and the .LDF file size should not increase (but it does slowly), I can't imagine we go through 1.87gig of transaction data per day...
K2.mdf 138meg
K2_log.LDF 1.87gig
K2Log.mdf 1.96gig
K2Log_Log.LDF 1.1gig
It was gradually increasing over a period of time.
I was able to verify that the log's internal space does get freed up each night.
Use SQL Server Management Studio, right click on database, tasks, shrink file, and just look at the Log file type and it tells you allocated space and available free space on the .MDF itself.
I will keep monitor the available free space to see if it's really using that much of transaction log on the K2 database.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.