Data Space Allocation | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data Space Allocation

I`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 inthis 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.