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) [...]
Archives
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
My Book
-
-
-
Disclaimer
The information on this blog is provided “AS IS” with no warranties, and confers no rights. I do not represent the thoughts, plans or strategies of my customers. It is solely my opinion. Challenge, disagree, or tell me I’m completely nuts in the comments section, but I reserve the right to delete any comment for any reason whatsoever (abusive, profane, etc)
Categories
- Applications (1)
- Backup (10)
- Benchmark IT Consulting (243)
- Business (4)
- Colin Stasiuk (239)
- General (64)
- Maintenance (14)
- Monitoring (14)
- PASS (53)
- Performance (4)
- Personal (18)
- Release Information (13)
- Security (14)
- SQL Azure (2)
- SQL Server (205)
- Tier1OnSQL (1)
- Training (4)
- Uncategorized (7)
- XML (2)
© 2012 | Powered by WordPress