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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-02 : 09:07:38
|
| Vic writes "My SQL Database is currently weighing in at aroung 40Mb + 10Mb overhead files. However, my SQL Server reports that I have 96Mb in use.Why is this, and how can I reduce it. I guess it relates to some inexpert use of indexes in early design stages." |
|
|
Jay99
468 Posts |
Posted - 2002-04-02 : 09:59:39
|
| How do you figure 40 + 10? Where is SQL Server reporting 96? Treduce the size of a database you need to shink and/or remove data/metadata. Take a look at 'Shrinking Databases' in BOL.Jay<O> |
 |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-04-02 : 10:01:26
|
| Where did you get the 40M+10M from?If you want to reduce the size of the database, you could try1) Shrinking it using the shrink command2) Getting rid of any unnecessary indexes3) Shortening the length of columns if possible4) Make sure it is at least at 3rd normalization level |
|
|
|
|
|
|
Database Size Issue