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

Sometimes we often encounter that database logs take up a lot of disk space because they are too large.

So when there is insufficient disk space, we need to clean up some log files that are too large on a regular basis.

1. Detach the log before cleaning

two。 Delete the database log, find the place where you store the database log, and delete it (ldf file, don't delete it wrong, don't worry about backup first).

3. Attach the database, because the data log no longer exists, when attaching, delete the log path.

Note: (when doing data separation, it is best to create a library and test it first to avoid misoperation that can not be recovered.)

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.