Shrinking log files on SQL Server 2008 R2

-
You know your having a bad day when you have to logon to a server to start running SHRINKFILE commands to free up disk space. Recently our Team City builds will start failing because an application API is down and when we track that through, we find that a Sql Server has run out of disk space. Doh!

I should continue by saying that I only ever do this on DBs that are part of the development environments. I would think twice and then probably go ask someone anyway before running these in UAT or Live environments.

SQL Server Database Files

Far to often the SQL Server data files (mdf) and the log files (ldf) grow to take up large amounts of space on the disk. We can empty the data by truncating the tables, or backing up the database, but this does not actually reduce the size of the files on disk - the same amount of space is still allocated.

Shrinking a file

You can shrink a file using the appropriately named SHRINKFILE switch of the DBCC command.


Links

For more information its worth having a read through these links:

Popular posts from this blog

A Simple 3 Layer Architecture

-
Image
A while ago I talked about the standard architectural approach at work . The truth is I'm not completely taken with putting an API in, particularly when its a small application. So how would an application look without the API? Well, I know all of the patterns, but I haven't actually put them together and had a poke around and understood the whys and wherefores of each design decision, so I thought I would give it a try...
Read more

Parsing Visual Studio Files with Powershell

-
Image
Most companies have some pretty complicated legacy code bases with a multitude of applications and shared libraries. It can be quite difficult to see how the solutions and projects fit together. With the push towards devops and microservices it’s nice if we can carry some of the legacy applications along too. I’ve found PowerShell a useful way to try to reason about a code base...
Read more