SQL Server Performance Forum – Threads Archive
Data Space AllocationI`ve only 60 MB free of data`s space. When this happened whith the transaction log space I resolve whit de truncate and shrink of the database. What i`ve to do in this case?. Thanks for your help!
What are the database settings and recovery model?
How often you backup the transaction logs? Check for any other jobs that are contributing this unexpected increase in size of transaction log, such as optimization or reindexing jobs during the day or night. Have a look around inthishttp://www.sql-server-performance.com/absolutenm/templates/?a=260&z=1 article and findout the reasons. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.