Rotating Header Image

Bad Advice (BACKUP LOG [mydb] WITH TRUNCATE_ONLY)

So I was doing my morning reading when I came across an article talking about someone who had a problem in their production environment with a transaction log that was too big. 

The author then gave their solution to this problem as a way to resolve it:

Backup log [mydb] with truncate_only
go
DBCC SHRINKFILE (2)
go

The author then followed this up with a “so if you ever get this problem run this script and you’ll be fine”.

 Very dangerous script to run in a production environment.  While this may solve the “my log file is too big” problem if you run this script you are going to be breaking your LSN chain and all future log backups will fail until you take a full or differential backup. 

I know a few people have written articles (sorry I can’t find/link to any right now) about giving bad advice online and that anything you read should NOT be taken as gospel.  You just need to make sure if you’re going to use a solution that you’ve seen online that you make sure that for your environment it’s the right solution. 

The online community is a wonderful place and I fully endorse the sharing of information…but

Authors:  Make sure to do your best to properly illustrate when you should/shouldn’t use potentially dangerous scripts like the one above along with the corresponding risks

Readers:  Make sure that you fully understand the solutions provided by the online community before implementing them into your production environment

As Jerry Springer would say: “Take care of yourself and each other”

Enjoy!!

Post to Twitter Post to Delicious Post to Digg Post to StumbleUpon

4 Comments

  1. […] out by eating all of the bacon as quickly as possible before pouring salt in the pan. I recalled a blog entry just two days ago by Colin Stasiuk and started looking for a possible correlation. Could it be […]

  2. […] out by eating all of the bacon as quickly as possible before pouring salt in the pan. I recalled a blog entry just two days ago by Colin Stasiuk and started looking for a possible correlation. Could it be […]

  3. Among many phones it released recently, the name of Motorola Moto Droid is worth mentioning. This top end smartphone is made out of premium ballasting nylon material that makes it durable as well as gives it a premium look

  4. The iPhone 7 line at Apple’s George Street flagship store is modest compared to previous years, but you can attribute most of that to the fact that Apple is now a lot better at selling its phones online as it was a few years ago

Leave a Reply

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.