SQL Server Performance Forum – Threads Archive
Log filled up diskRight now im trying to get up my cluster for SQL as one of the LOG Database grew out of control. When i finally get up system. To clear out the LOG which is 32 gig Do i just right click in enterprise and do srhink log file.
Transaction log out of hands, in this case you have to check whether transaction log backup is performed regularly.
Also check what kind of processes, queries running on the server causing this Tr.log to grow.
There is no use in shrinking the log if other processes are contributing a lot, by performing regular backups you can control the sizes, for the sake of recoverability it is better to take care with backup and not to put as SIMPLE recovery model. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.