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

"Rob Wahmann" <dotcomstudio (AT) sbcglobal (DOT) net> wrote

Umm, either you don't have nearly the data yu think you have (a 2000:1 ratio
is HUGE) or something very weird is going on.

For starters, make sure you're not including the transaction log in that
size.

If you are, do a transaction log backup and then truncate the transaction
log.

"Rob Wahmann" <dotcomstudio (AT) sbcglobal (DOT) net> wrote

I'm guessing you have full logging turned on, but never do any transaction
log backups.

If you want full logging, make sure you do transaction backups.

If you don't care about full logging, use simple recovery mode.

If you want something quick and dirty try:

backup log foo with truncate_only

That will truncate the log file to the last active transaction. (note you
should do a full backup immediately after that.)

Where exactly do I run these commands? I'm not very familiar with this stuff


Thanks again!

Rob


"Greg D. Moore (Strider)" <mooregr (AT) greenms (DOT) com> wrote

"Rob Wahmann" <dotcomstudio (AT) sbcglobal (DOT) net> wrote

Not a problem.


Glad it worked. (I guess you figured out where to run them. :-)