开发者

Problem with size of my SQL Server Log file

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜