sql size vs. access size

[Rob Wahmann]

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

[Greg D. Moore \(Strider\)]

Re: sql size vs. access size


"Rob Wahmann" <dotcomstudio@s bcglobal.net> wrote in message
news:LidUa.2551 5$BM.8256484@ne wssrv26.news.pr odigy.com...[color=blue]
> 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?[/color]

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.

[color=blue]
>
> Thanks in advance! Rob
>
>[/color]

[Daniel Bush]

Re: sql size vs. access size

On Fri, 25 Jul 2003 16:56:11 GMT, "Rob Wahmann"
<dotcomstudio@s bcglobal.net> wrote:
[color=blue]
>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
>[/color]

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.danbu sh.com

[Greg D. Moore \(Strider\)]

Re: sql size vs. access size


"Rob Wahmann" <dotcomstudio@s bcglobal.net> wrote in message
news:IqaVa.2748 5$BM.8916648@ne wssrv26.news.pr odigy.com...[color=blue]
> Thanks guys! It is the log file and now I'm trying to figure out how to
> reduce the size. The actual database is only 6 mb. I appreciate your help!
>[/color]

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.)

[color=blue]
> Rob
>
> "Rob Wahmann" <dotcomstudio@s bcglobal.net> wrote in message
> news:LidUa.2551 5$BM.8256484@ne wssrv26.news.pr odigy.com...[color=green]
> > I have a SQL Server database that is showing 2853.44 mb in size but when[/color][/color]
I[color=blue][color=green]
> > export the data into MS Access the size is less than 1 mb. Can anyone[/color][/color]
tell[color=blue][color=green]
> > me how to reduce the size of my SQL Server database so that it's less[/color][/color]
than[color=blue][color=green]
> > 15 mb?
> >
> > Thanks in advance! Rob
> >
> >[/color]
>
>[/color]

[Rob Wahmann]

Re: sql size vs. access size

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

Thanks again!

Rob


"Greg D. Moore (Strider)" <mooregr@greenm s.com> wrote in message
news:xBuVa.1350 79$EQ5.76483@tw ister.nyroc.rr. com...[color=blue]
>
> "Rob Wahmann" <dotcomstudio@s bcglobal.net> wrote in message
> news:IqaVa.2748 5$BM.8916648@ne wssrv26.news.pr odigy.com...[color=green]
> > Thanks guys! It is the log file and now I'm trying to figure out how to
> > reduce the size. The actual database is only 6 mb. I appreciate your[/color][/color]
help![color=blue][color=green]
> >[/color]
>
> 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.)
>
>[color=green]
> > Rob
> >
> > "Rob Wahmann" <dotcomstudio@s bcglobal.net> wrote in message
> > news:LidUa.2551 5$BM.8256484@ne wssrv26.news.pr odigy.com...[color=darkred]
> > > I have a SQL Server database that is showing 2853.44 mb in size but[/color][/color][/color]
when[color=blue]
> I[color=green][color=darkred]
> > > export the data into MS Access the size is less than 1 mb. Can anyone[/color][/color]
> tell[color=green][color=darkred]
> > > me how to reduce the size of my SQL Server database so that it's less[/color][/color]
> than[color=green][color=darkred]
> > > 15 mb?
> > >
> > > Thanks in advance! Rob
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Greg D. Moore \(Strider\)]

Re: sql size vs. access size


"Rob Wahmann" <dotcomstudio@s bcglobal.net> wrote in message
news:EaFVa.2831 8$BM.9307001@ne wssrv26.news.pr odigy.com...[color=blue]
> Worked beautifully... thanks!
>[/color]

Not a problem.


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