Life is like Code, you never know what you will create next

How to Shrink a SQL Transaction Log File

13. September 2010 13:58 by Scott in   //  Tags:   //   Comments (42)

I was having trouble with a transaction log file that had unrestricted growth set.  I needed to get it down to a good size without killing my disk space.  So below is the script I used to shrink the transaction log after it had gone a little wild with size.

log 'yourdatabasename' to disk ='D:\YourdatabaseName.trn'
shrinkfile (yourdatabase_logfilename,1)
If you liked this post, please be sure to subscribe to my RSS Feed.

Comments (42) -

6/23/2013 8:37:40 PM #

Tableau compatibilite astrologique busty    question gratuite de  voyance -
6/24/2013 4:27:31 PM #

Why people still make use of to read news papers when in this technological globe all is existing on web?

Here is my homepage table à langer murale [ - ]
7/4/2013 4:52:30 AM #

We're a group of volunteers and opening a new scheme in our community. Your web site offered us with helpful information to work on. You have done a formidable activity and our whole group will be grateful to you.

Visit my page :: -

best steam mop on the market
best steam mop on the market
7/10/2013 8:54:31 PM #

I enjoy this site - its so usefull and helpfull.

Feel free to visit my web page ::  best steam mop on the market -

tirage tarot
tirage tarot
7/17/2013 12:00:02 AM #

L internaute horoscope scorpion ejaculate  tirage de 32 carte

my web-site ::  tirage tarot -

tirage tarot
tirage tarot
7/17/2013 11:09:32 PM #

Forum voyance aufeminin ejaculate  avenir selon les tarot

Take a look at my page ...  tirage tarot -

7/19/2013 5:42:41 PM #

When I originally left a comment I appear to have clicked on the -Notify me when new comments are added- checkbox and now whenever a comment is added I recieve four emails with the exact same comment. There has to be a means you can remove me from that service? Appreciate it!

my homepage ... Wasserdichte Kamera ( Nicholas - )
7/21/2013 2:04:14 PM #

Hi! Do you use Twitter? I'd like to follow you if that would be okay. I'm absolutely enjoying your blog and look forward to new posts.

Look into my webpage :: Wasserdichte Kamera ( - )

7/22/2013 3:14:36 AM #

I have been browsing online more than three hours lately, but I never found any fascinating article like yours. It is lovely worth enough for me. In my opinion, if all web owners and bloggers made just right content material as you did, the net will likely be a lot more useful than ever before.

Also visit my web page Wasserdichte Kamera -  Randell -  -

Laubsauger Test
Laubsauger Test
7/22/2013 8:22:30 AM #

I read this paragraph completely about the comparison of most up-to-date and preceding technologies, it's remarkable article.

My website ::  Laubsauger Test -
7/22/2013 1:13:53 PM #

Hello are using Wordpress for your blog platform? I'm new to the blog world but I'm trying to get started and set up my own. Do you need any html coding expertise to make your own blog? Any help would be really appreciated!

Look at my web-site; Laubsauger Test - -  -
7/23/2013 6:36:06 AM #

Whoa! This blog looks exactly like my old one! It's on a completely different subject but it has pretty much the same page layout and design. Outstanding choice of colors!

Also visit my blog post Wasserdichte Kamera ( - )
7/23/2013 6:43:45 AM #

I love your blog.. very nice colors & theme. Did you design this website yourself or did you hire someone to do it for you? Plz answer back as I'm looking to design my own blog and would like to find out where u got this from. many thanks

Also visit my weblog :: Laubsauger Test - -  -

7/23/2013 9:34:31 AM #

I am regular visitor, how are you everybody? This article posted at this web site is truly nice.

My web site :: wasserpumpe mit solar * Carmen - *

videokamera wasserdicht
videokamera wasserdicht
7/23/2013 4:04:19 PM #

Do you have a spam problem on this blog; I also am a blogger, and I was wanting to know your situation; we have created some nice practices and we are looking to exchange techniques with other folks, please shoot me an email if interested.

Also visit my site -  videokamera wasserdicht -

laubsauger ersatzteile
laubsauger ersatzteile
7/25/2013 12:12:55 AM #

Hi there! This is my first visit to your blog! We are a team of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a marvellous job!

Look at my webpage ::  laubsauger ersatzteile -

7/26/2013 9:55:27 PM #

What's Happening i'm new to this, I stumbled upon this I have found It positively useful and it has helped me out loads. I hope to contribute & help other users like its aided me. Great job.

Feel free to visit my web-site; Wasserdichte Kamera ( Agcsb.Com - )

chaussure de football
chaussure de football
8/4/2013 4:51:22 PM #

These are actually fantastic ideas in on the topic of blogging. You have touched some fastidious factors here. Any way keep up wrinting.

my web site;  chaussure de football -

chaise de bar pas cher
chaise de bar pas cher
8/5/2013 7:41:39 AM #

I'm gone to inform my little brother, that he should also pay a visit this weblog on regular basis to get updated from most recent news update.

Look at my site ::  chaise de bar pas cher -

ceramic watches
ceramic watches
8/5/2013 12:46:03 PM #

Hi there, I desire to subscribe for this blog to get hottest updates, so where can i do it please assist.

Feel free to surf to my web page -  ceramic watches -

Voyance en Ligne
Voyance en Ligne
8/5/2013 4:40:56 PM #

Horoscope aubry compatibilite amoureuse astrologique gratuite

My site;  Voyance en Ligne -

walkers with seats for the elderly
walkers with seats for the elderly
8/6/2013 6:24:59 AM #

Write more, thats
all I have to say. Literally, it seems as though you relied on the video to make your point.
You clearly know what youre talking about, why throw
away your intelligence on just posting videos to your blog when you could
be giving us something enlightening to read?

Look into my web page:  walkers with seats for the elderly -

wheelchair Tucson
wheelchair Tucson
8/6/2013 6:32:42 AM #

Hey! Do you know if they
make any plugins to protect against hackers? I'm kinda paranoid about
losing everything I've worked hard on. Any tips?

Feel free to visit my website ::  wheelchair Tucson -

power wheelchairs reviews
power wheelchairs reviews
8/6/2013 6:33:57 AM #

Hello just
wanted to give you a quick heads up. The words in your article
seem to be running off the screen in Safari.
I'm not sure if this is a format issue or something to do with
internet browser compatibility but I thought I'd post to let you know.
The design and style look great though! Hope you get
the problem resolved soon. Thanks

My blog -  power wheelchairs reviews -

lightweight wheelchairs for Sale
lightweight wheelchairs for Sale
8/6/2013 6:37:23 AM #

I'm really enjoying the design and layout of your site. It's
a very easy on the eyes which makes it much more enjoyable for me to come
here and visit more often. Did you hire out a designer to create your theme?
Excellent work!

Also visit my blog -  lightweight wheelchairs for Sale -

heavy duty extra wide rollator
heavy duty extra wide rollator
8/6/2013 6:39:48 AM #

Howdy admin, I just wanted to give you a quick heads
up that your current Domain name: is being flagged as a
potentially malicious blog in
my web browser firefox. I'd highly suggest having someone look
into it. You can
lose a lot of guests due to this kind of
issue. Best of Luck.

Here is my blog post:  heavy duty extra wide rollator -

mobility scooter reviews consumer reports
mobility scooter reviews consumer reports
8/6/2013 6:40:17 AM #

Currently it seems like Movable Type is the preferred blogging platform available right now. (from what I've read) Is that what you are using on
your blog?

Feel free to visit my weblog:  mobility scooter reviews consumer reports -

passerelle multimedia
passerelle multimedia
8/7/2013 12:46:44 AM #

Have you ever considered publishing an ebook or guest authoring on other sites? I have a blog based on the same ideas you discuss and would really like to have you share some stories/information. I know my audience would value your work. If you are even remotely interested, feel free to shoot me an e-mail.

Here is my homepage -  passerelle multimedia -

Mobility Scooters Columbus
Mobility Scooters Columbus
8/7/2013 5:53:44 AM #

Hi there, i read your
blog occasionally and i own a similar one and i was just
curious if you get a lot of spam feedback? If so how do
you protect against it, any plugin or anything you can advise? I get so much lately it's driving me mad so any
support is very much appreciated.

My web blog -  Mobility Scooters Columbus -

forclosure homes
forclosure homes
8/7/2013 6:40:39 AM #

Great web site you've got here.. It's difficult to find good quality writing like yours these days. I truly appreciate people like you! Take care!!

Stop by my webpage ...  forclosure homes -

jeu de tarot gratuit
jeu de tarot gratuit
8/9/2013 11:21:01 AM #

Voyance privee par telephone tarot au feminin domino

Also visit my web-site  jeu de tarot gratuit -

8/12/2013 4:58:30 AM #

It's actually very difficult in this active life to listen news on Television, therefore I just use world wide web for that purpose, and take the most up-to-date news.

my weblog;  减肥药排行榜 -
8/13/2013 11:58:35 AM #

I've been exploring for a little bit for any high-quality articles or blog posts on this sort of area . Exploring in Yahoo I eventually stumbled upon this site. Studying this information So i am happy to exhibit that I've a very just right uncanny feeling I discovered exactly what I needed. I such a lot definitely will make certain to don?t fail to remember this site and give it a look regularly.

Also visit my page - tablette graphique ( - )
8/14/2013 5:26:42 AM #

The coffee maker is truly an essential part of many kitchen areas and of numerous mornings! you will need in order to keep the coffee maker clean up to ensure that it to create the latest coffee for the daily enjoyment. It will recommended to wash the glass cooking pot daily along with warm soapy liquid but people simply supply an easy rinse and prepare an additional cooking pot great away forgetting to clean the collecting oil off the inside of.

my web site depression ( - )
8/14/2013 8:38:44 AM #

Wonderful post! We will be linking to this particularly great post on our site. Keep up the great writing.

Take a look at my web blog -

turbine a glace professionnel
turbine a glace professionnel
8/15/2013 8:32:35 PM #

I all the time emailed this web site post page to all my friends, for the reason that if like to read it next my friends will too.

Take a look at my website  turbine a glace professionnel -

power wheelchairs cost
power wheelchairs cost
8/15/2013 9:33:48 PM #

First of all I want to say fantastic blog! I had a quick question
in which I'd like to ask if you don't mind. I was interested
to know how you center yourself and clear your mind prior to writing. I have had
trouble clearing my mind in getting my ideas out. I truly do enjoy writing but it just seems like
the first 10 to 15 minutes are generally lost just trying to figure out how to begin. Any ideas
or hints? Many thanks!

Also visit my web blog ::  power wheelchairs cost -

medium gratuit
medium gratuit
8/16/2013 10:29:29 AM #

Voyance des anges tatouage signe astrologique taureau

My web-site;  medium gratuit -

medium gratuit
medium gratuit
8/17/2013 7:55:17 AM # horoscope chinois gratuit de la semaine

Feel free to surf to my webpage  medium gratuit -

medium gratuit
medium gratuit
8/19/2013 1:47:59 AM #

Affinites signes astro tirage tarot jour

Feel free to visit my web page ...  medium gratuit -

voyance gratuite
voyance gratuite
8/23/2013 8:08:04 PM #

Rtl horoscope 2012 horoscope verseau octobre

Take a look at my webpage;  voyance gratuite -

films x
films x
8/24/2013 1:20:31 AM #

Filme prono lesbienn sexy

my blog post:  films x -