Discussion Locked

SQL server - Transaction Log Recovery

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have single disk on which sql server is running and while working on sql server i found that my tranaction log has grown up and eat up full disk space, Please suggest how to make free space to tackle this issue. As process is online has i can't make sql server down.

3 replies

by carlos.nino

You can't put the server down but ?can you edit the log?, or change the server's prefferences as to filter what is logged and what not?

by nofodkg

1)Do you do "full database backup"? How often do you backup your databases? In my case I have a script that truncates the log just after a full backup because the log is no longer needed.
2)Backup the log on remote disk or server on the network.

Hope this help

This discussion is closed to new replies.