Shulou(Shulou.com)06/01 Report--

If the log of sql server is too large, log truncation is required. Log in to sql server to select the database, open the properties, adjust the log level from complete to simple, and click OK. At this point, the large log files in the past have become useless.

Open the properties again and change the log level from simple to complete.

Select database, select shrink, select log. You can see that 99% of them are available. Click OK, and the sql server will shrink and will be finished soon.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.