Shrink SQL Server TransactionLogs

On my SharePoint development VM the harddisk space was empty but there was no reason why. I have spend a while till i found out that the SharePoint database files were quite big. Specially the TransactionsLogs from the databases. I opened the SQL Mgmt Studio and tried to shrink the Transaction Log DBs but i wasn’t successful.

The solution was to change the recovery model to ‘simple’ or to make a log backup then the shrink works. Afterwards the log database was nearly empty again and my harddisk space problem was solved.

Related Posts

No related posts.