Shrink Database SQL Server 2005

June 4, 2009

USE dbName
GO
DBCC SHRINKFILE (dbName_Log, 1)
BACKUP LOG  dbName WITH TRUNCATE_ONLY
DBCC SHRINKFILE (dbName_Log, 1)
Share and Enjoy:
  • Twitter
  • Google Buzz
  • DZone
  • Digg
  • Reddit
  • Diigo
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • LinkedIn
  • Mixx
  • email
  • PDF
  • Add to favorites

tags:
posted in MS SQL Server by phani

Follow comments via the RSS Feed | Leave a comment | Trackback URL

Leave Your Comment

 
Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org