Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
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 !!!!!!