Mydatabase.LDF file size is greater than Mydatabase.MDF 1

[smuralig]

Hi,

What could be the reason for the logfile ( .LDF ) size is greater than datafile ( .MDF ) size in DATA folder of database server and How to solve the problem ?

Please help,

Thanks and Regards,

Murali

 

[ClaireHCM]

1.issue Checkpoint
2.Backup log with trncate_only --(if full recovery model)
step 2 can be skipped if with simple recovery model
3.DBCC srinkfile (logfile name)

 

[SQLBill]

Are you doing backups?

Are you just doing a FULL BACKUP?

You should be doing full backups and either backing up the transaction log or doing what Claire suggests.

For Your Knowledge- the transaction log is a log of EVERY transaction that took place since the last full backup.

-SQLBill

 

[SQLBill]

TYPO Alert:

This:

For Your Knowledge- the transaction log is a log of EVERY transaction that took place since the last full backup.


Should have read:

For Your Knowledge- the transaction log is a log of EVERY transaction that took place since the last transaction log backup.

-SQLBill

 

[smuralig]

Thank you ClaireHsu and SQLBill,

I issueed Checkpoint in QA and then shrinkfile in EM. The log file became to normal size then. This had done with the user sa. But In begining I tried to do the same with another user which has got dbo role was not possible. what could be the wrong.

Thanks and Regards,

Murali