1
kudos
spam Kudos Remove

Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!
published 1026 days, 21 hours, 23 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1030 days, 17 hours, 37 minutes ago
Friday, July 31, 2009 12:11:33 PM GMT Monday, July 27, 2009 3:57:49 PM GMT
Aaron Bertrand : Oh, the horror! Please stop telling people they should shrink their log files!

I realize that there are some cases where, in an emergency, you need to shrink a log file because it took over the drive.  In SQL Server 2005 and earlier, you could get out of the jam quickly, by issuing a BACKUP LOG WITH TRUNCATE_ONLY (followed by DBCC SHRINKFILE).  In SQL Server 2008, this "feature" within BACKUP LOG is no longer available, and with good reason; however, there are other - shall we say, "clever" - ways to achieve this.  But too many people pass this advice off casually, and this gives p...

category: Management | clicked: 3 | | source: sqlblog.com | show counter code
tags: LogFile, LOGS, SQL Server 2005, SQL Server 2008

No comments yet, be the first one to post comment.

To post your comment please login or signup