skip to main | skip to sidebar

ActiveInfo

Sunday, March 21, 2010

Shrinking Log File for SQL Server

DBCC SHRINKFILE({Database Name}_log, 1)
BACKUP LOG {Database Name}WITH TRUNCATE_ONLY
DBCC SHRINKFILE({Database Name}_log, 1)
Posted by Ofer Narkis at 1:28 PM No comments:
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Blog Archive

  • ▼  2010 (2)
    • ►  April (1)
    • ▼  March (1)
      • Shrinking Log File for SQL Server
  • ►  2009 (12)
    • ►  May (6)
    • ►  April (2)
    • ►  March (3)
    • ►  February (1)
  • ►  2008 (11)
    • ►  December (3)
    • ►  October (5)
    • ►  September (1)
    • ►  February (2)
  • ►  2007 (1)
    • ►  May (1)

Contributors

  • Ofer Narkis
  • Ofer Narkis