Size of K2 databases?

  • 4 March 2010
  • 1 reply
  • 11 views

Badge +4

Hi,


On my test environment, I have been testing out some processes.  I notice that in SQL server management studio, if I check the properties of my K2Server database, it is very large - about 12 GB.  This compared to between 1 and 2 gb on my production server.


Further investigation on the actual machine showed that there are two files associated with this database, an MDF file and an LDF file.


The MDF file is of normal size, but the LDF file is almost 11GB.


What does this mean?


Thanks in advance.


1 reply

Badge +5

Hi,


The .ldf file is the  the transaction log for the associated database, which makes it possible to recover the database in case of a crash. This file will also be used by SQL to keep track of transactions and the data involved to Commit or Rollback.


The following link will describe methods of how to safely shrink the log file:


http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/ce37cb15-f78b-431d-8e71-7298a9cb8f27


 


Cheers,
Gert

Reply