How to Shrink Your Sql Server Log Files#
http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/ Assuming SMS is your database name and sms_log is your transaction log name: USE SMS GO DBCC SHRINKFILE(sms_log, 1) BACKUP LOG sms WITH TRUNCATE_ONLY DBCC SHRINKFILE(sms_log, 1)
Thursday, September 11, 2008 2:48:48 PM (Central Standard Time, UTC-06:00) #    Comments [0]  | 

 

All content © 2009, prag
On this page
How to Shrink Your Sql Server Log Files
This site
Syndicate
Calendar
<January 2009>
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567
Archives
 Full Archives By Category
December, 2008 (2)
November, 2008 (5)
October, 2008 (2)
September, 2008 (2)
July, 2008 (3)
June, 2008 (2)
March, 2008 (2)
February, 2008 (1)
January, 2008 (3)
December, 2007 (2)
November, 2007 (2)
October, 2007 (8)
September, 2007 (2)
July, 2007 (1)
May, 2007 (1)
January, 2007 (1)
December, 2006 (1)
November, 2006 (12)
October, 2006 (8)
September, 2006 (15)
August, 2006 (3)
July, 2006 (3)
June, 2006 (17)
May, 2006 (9)
April, 2006 (1)
March, 2006 (6)
February, 2006 (6)
January, 2006 (3)
December, 2005 (6)
November, 2005 (1)
October, 2005 (2)
September, 2005 (6)
August, 2005 (7)
July, 2005 (5)
June, 2005 (8)
May, 2005 (11)
April, 2005 (14)
March, 2005 (7)
Sitemap
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Blogroll OPML
 Healthy Reader
 Pop Therapy
 Slippery Brick
 The Art of Ware
 Wealthy Reader
 What's your 20
Disclaimer

Powered by: newtelligence dasBlog 1.9.6264.0

The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

Send mail to the author(s) E-mail

Theme design by Jelle Druyts