MS-SQL log file size has been many management headaches,Previously also noticed a different Server log files and some great,Some very small,Internet search articles,Find problems。
該留 not debate issues not log 檔該 這邊,Talk about how to make fitness log。
Right-click the name of the database to select "Properties",Switch to the "Options","Recovery" under the "model",In the drop-down menu and select "Simple",In this way you can significantly reduce the magnitude of the rise of the log file。