Manage Ldf(log file) in Ms sql server 2k - TechRepublic
General discussion
June 1, 2004 at 08:53 PM
j_brown382003

Manage Ldf(log file) in Ms sql server 2k

by j_brown382003 . Updated 21 years, 11 months ago

one of my database’s log file (ldf) is reaching 3 Gigabyte of hardisk space, and it make the database error. by reading the help, I already make the transactional log backup, and it solve the error, but how do I reduce that ldf? can I make it become under 1 GB?

This discussion is locked

All Comments