On Fri, 25 Jul 2003 16:56:11 GMT, "Rob Wahmann"
<do**********@sbcglobal.net> wrote:
I have a SQL Server database that is showing 2853.44 mb in size but when I
export the data into MS Access the size is less than 1 mb. Can anyone tell
me how to reduce the size of my SQL Server database so that it's less than
15 mb?
Thanks in advance! Rob
Check and see if the database in question is included in your
"Database Maintenance Plan". If so, make sure that "Reorganize Data
and Index Pages" option is checked and "Change Free Space Percentage"
is set to something reasonable, like 10%.
If you don't have a "Database Maintenance Plan", you probably need
one. Add one, then run it manually through the "Jobs" tab in
Enterprise manager - afterwards check the size.
Dan Bush
me@REMOVE.danbush.com