SQL database log file is full, how to delete

xiaoxiao2021-03-06  18

Source: http://blog.9cbs.net/angelz/1. Empty Log DUMP Transaction Database name with no_log 2. Shrinkage database file (if not compressed, database files do not reduce Enterprise Manager - Right click, you have to compress Database - All Tasks - Shrink Database - Shrink File - Select Log File - Select to shrink to XXM in the shrink mode, here a minimum M number allowed to shrink, directly enter this number, determine Yes - Select Data File - Select to shrink to XXM in the shrink mode, here will give a minimum number of Mixes to shrink, directly enter this number, determine it.

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

New Post(0)