Transaction Logs

If you’re receiving backup copies of client databases, to do customizations or migrations on, and they haven’t been truncating their transaction logs, it’s not unusual for a restored database to have a 3 GB .log file attached to it.

Those can fill up the space on a VPC very quickly.

To shrink them down to size, right-click on the database in SSMS, and select Properties. In the Options section, set the Recovery model to Simple, and click OK.

Right-click on the database again in SSMS, and select Tasks -> Shrink -> Database. Click OK.

Voila. No more Gigabytes.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: