Category Archives: SQL Server

Moving a SQL Server 2005 transaction log

Since I don’t do this very often, I always have to refresh my memory on the process. It is easily found via your favorite search engine, but since part of my reason for this blog is to consolidate the places … Continue reading

Posted in SQL Server | Leave a comment

Shrinking SQL Server 2005 log files – part deux

In Shrinking SQL Server 2005 log files I gave some standard approaches to shrinking transaction logs. I was having trouble making those work on a development server, due in part to an extreme shortage of disk space. I came up … Continue reading

Posted in SQL Server | 2 Comments

Shrinking SQL Server 2005 log files

Note: for the purposes of this article I am assuming a full recovery model (which is the default). I have occasionally had database transaction logs grow out of control on SQL Server 2005, e.g. 100M of data and 5G of … Continue reading

Posted in SQL Server | 6 Comments