Discussion Locked

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

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by john.clayton

Try shrinking the database in SQL server. In Enterprise Manager, select the database, all tasks, and shrink database.

This discussion is closed to new replies.