SQL database log file is full, how to delete

xiaoxiao2021-03-06  20

1. Clear Log Dump Transaction Database name with no_log

2. Shrink the database file (if not compressed, the database files do not reduce the enterprise manager - Right click on the database you want to compress - All Tasks - Shrink Database - Shrink File - Select Log File - In Shrink Mode The choice to shrink to XXM, here will give a minimum M number that is allowed to shrink, enter this number directly, determine it - select data file - Select shrinkage to XXM in the shrink mode, here will give a permission The minimum number of shrinks is contracted, enter this number directly, it is ok.

转载请注明原文地址:https://www.9cbs.com/read-42042.html

New Post(0)