THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
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 ...
July 27, 2009
Brought to you by