Amir Mirkamali RSS 2.0
 Wednesday, January 21, 2009

if you want to shrink database log file just run this codes with your database name:

BACKUP LOG yourdbname WITH TRUNCATE_ONLY
DBCC SHRINKFILE(yourdbname_log, 2)

this code will shrink and reduce your database log file to 2MB

 

Wednesday, January 21, 2009 7:04:33 AM UTC  #    -
SQL Server
Archive
<January 2009>
SunMonTueWedThuFriSat
28293031123
45678910
11121314151617
18192021222324
25262728293031
1234567
Blogroll
About the author/Disclaimer

استفاده از مطالب سایت با ذکر منبع آزاد است

© Copyright 2012
Amir Mirkamali

Statistics
Total Posts: 40
This Year: 0
This Month: 0
This Week: 0
Comments: 1
Themes
All Content © 2012, Amir Mirkamali