In my database on SQL 2008 Express Advanced
Recovery Model is full
AutoShrink is falseWhen 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.
精彩评论