Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
lols
Posting Yak Master
174 Posts |
Posted - 2010-11-30 : 01:30:08
|
In my database on SQL 2008 Express AdvancedRecovery Model is fullAutoShrink is falseWhen I ran sp_spaceused, I got the following;database_name db_size unallocated_space FreeLearningTuts 1398.13 MB 0.73 MBreserved data index_size unused211216 KB 207024 KB 2944 KB 1248 KB Out of this, the size of the data in tables is 150MB but the entire table 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.Is it a good idea to reduce the log file and how should it be done so that live website users are not effected? |
|
antony_dba
Starting Member
26 Posts |
Posted - 2010-11-30 : 01:33:00
|
you better change the transaction log size from database rightclick ->propertiesthere select files in left pane and change the growth of log fileso you get database size will be lowerkris |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
|
|