473,320 Members | 1,867 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

sql size vs. access size

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
Jul 20 '05 #1
5 4020

"Rob Wahmann" <do**********@sbcglobal.net> wrote in message
news:Li********************@newssrv26.news.prodigy .com...
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?
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.


Thanks in advance! Rob

Jul 20 '05 #2
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
Jul 20 '05 #3

"Rob Wahmann" <do**********@sbcglobal.net> wrote in message
news:Iq********************@newssrv26.news.prodigy .com...
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!

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

Rob

"Rob Wahmann" <do**********@sbcglobal.net> wrote in message
news:Li********************@newssrv26.news.prodigy .com...
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


Jul 20 '05 #4
Where exactly do I run these commands? I'm not very familiar with this stuff
:)

Thanks again!

Rob
"Greg D. Moore (Strider)" <mo*****@greenms.com> wrote in message
news:xB********************@twister.nyroc.rr.com.. .

"Rob Wahmann" <do**********@sbcglobal.net> wrote in message
news:Iq********************@newssrv26.news.prodigy .com...
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!

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

Rob

"Rob Wahmann" <do**********@sbcglobal.net> wrote in message
news:Li********************@newssrv26.news.prodigy .com...
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



Jul 20 '05 #5

"Rob Wahmann" <do**********@sbcglobal.net> wrote in message
news:Ea********************@newssrv26.news.prodigy .com...
Worked beautifully... thanks!


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

Jul 20 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: kuhni | last post by:
Hi everybody! After searching newsgroups for a couple of hours, I now try asking directly (running the risk of asking again the same question). My problem is to predict when the size of the...
8
by: Ron | last post by:
Hi all, How do I determine the size of the tables I'm using? I looked under properties and it's not there. The book I just browsed said table is limited to 1GB. How do I find out what size my...
3
by: Knick via AccessMonster.com | last post by:
I am novice to MS Access Development, I regularly back my access database every 2, 3 days ...today when I was going to back my database I saw the access file on the network drive was only 9 MB...
5
by: John | last post by:
Hi I have a typical front end/back end access app. Additionally a vb.net app accesses the backend mdb file every few minutes and runs insert and update queries on some table. The data to be...
11
by: mast2as | last post by:
This question has been posted to this forum before and I read the thread but found that the answers were perhaps imcomplete, so I am trying again. Whenever I am creating objects I would like to...
1
by: colmkav | last post by:
Can someone tell me how to check the size of an access database in VB code? I want to write code to check the size and then compact it if it is greater than this size.
6
by: Ian | last post by:
I am trying to get MS Access 2000 to print names and addresses onto a Dymo 400 label printer, I have set the Access Report to automatically select the correct printer, then select the label size of...
19
by: sphinney | last post by:
My company is in the process of upgrading everyone to Access 2007. Since my machine was upgraded I've been highly frustrated with an apparent random behaviour byAccess that I can't understand. It...
4
by: leegold58 | last post by:
Hi, Is there a "way around" the size limitation for Access? I'm thinking of something like spanning a huge table accross multiple databases... Something simple and that would preserve the...
33
by: Adam Chapman | last post by:
Hi, Im trying to migrate from programming in Matlab over to C. Im trying to make a simple function to multiply one matrix by the other. I've realised that C can't determine the size of a 2d...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.