Skip to main content
1-Visitor
April 9, 2011
Question

if you have any problems with the size of log files in Sql I suggest you do the following command:

  • April 9, 2011
  • 0 replies
  • 988 views

1.Open DB properties, Options page. Set recovery model to Simple.
2.Right-click DB node on the left, select Tasks->Shrink->Files, select Log in File type drop down list, make a notice of available free space, click OK.

Ps: the size of logs in the LDB has reduced by a-68go> 512 kb !!!!!!