Sunday, September 18, 2011

Truncate Log FIle in SQl Server

dbcc shrinkfile(accord_log,2)
backup log accord with truncate_only
dbcc shrinkfile(accord_log,2) 

No comments:

Post a Comment