Narrowing the MS-SQL database log file size

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。

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.