Select the database that needs to shrink the log, right-click Properties-Options, and change the recovery mode to simple.
650) this.width=650; "title=" QQ picture 20141229141044.jpg "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/57/A1 /wkiol1sg83ytcuh3aaruahsla9w538.jpg "alt=" Wkiol1sg83ytcuh3aaruahsla9w538.jpg "/>
Select the database, right-task-shrink-file.
650) this.width=650; "title=" 1 "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M01/57/A3/ Wkiom1sg8sri7450aak1ezebu6s957.jpg "alt=" Wkiom1sg8sri7450aak1ezebu6s957.jpg "/>
Change the file type to log, OK.
650) this.width=650; "title=" 2 "style=" Float:none; "src=" http://s3.51cto.com/wyfs02/M02/57/A1/ Wkiol1sg833s2ihoaakagr4wkoi294.jpg "alt=" Wkiol1sg833s2ihoaakagr4wkoi294.jpg "/>
Change the recovery mode of step one to the original configuration
Shrink period does not affect database run
This article is from the "Lixiangqian" blog, make sure to keep this source http://lixiangqian.blog.51cto.com/2848430/1597213
SQL Server 2008 Shrinking things logs