开发者

Problem with size of my SQL Server Log file

开发者 https://www.devze.com 2023-01-27 18:44 出处:网络
In my database on SQL 2008 Express Advanced Recovery Model is full AutoShrink is false When I ran sp_spaceused, I got the following;

In my database on SQL 2008 Express Advanced

Recovery Model is full

AutoShrink is false

When I ran sp_spaceused, I got the following;

database_name           db_size         unallocated_space   
FreeLearningTuts        1398.13 MB       0.73 MB

rese开发者_Go百科rved    data           index_size          unused
211216 KB   207024 KB      2944 KB      1248 KB

Out of this, the size of the tables is 150MB but db size shows 1398.13. It's probably the size of the log file. Can you tell what should I do to reduce the size of the Database.

Does anything look wrong with my DB from the figures above or are these the figures that a healthy db shows?


Do you do regular log backups? If not, the log will keep growing until you hit the maximum db size for SQL Express.

0

精彩评论

暂无评论...
验证码 换一张
取 消