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
5  4040 
"Rob Wahmann" <do**********@s bcglobal.net> wrote in message
news:Li******** ************@ne wssrv26.news.pr odigy.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
On Fri, 25 Jul 2003 16:56:11 GMT, "Rob Wahmann"
<do**********@s bcglobal.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.danbu sh.com
"Rob Wahmann" <do**********@s bcglobal.net> wrote in message
news:Iq******** ************@ne wssrv26.news.pr odigy.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**********@s bcglobal.net> wrote in message
news:Li******** ************@ne wssrv26.news.pr odigy.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
Where exactly do I run these commands? I'm not very familiar with this stuff
:)
Thanks again!
Rob
"Greg D. Moore (Strider)" <mo*****@greenm s.com> wrote in message
news:xB******** ************@tw ister.nyroc.rr. com...
"Rob Wahmann" <do**********@s bcglobal.net> wrote in message
news:Iq******** ************@ne wssrv26.news.pr odigy.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**********@s bcglobal.net> wrote in message
news:Li******** ************@ne wssrv26.news.pr odigy.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
"Rob Wahmann" <do**********@s bcglobal.net> wrote in message
news:Ea******** ************@ne wssrv26.news.pr odigy.com... Worked beautifully... thanks!
Not a problem.
Glad it worked. (I guess you figured out where to run them. :-) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 database (1GB I expect) is
over 1GB by calculating the maximal number of data sets (tuple) added:
1. Is the following calculation for estimating the mdb file size in
Access 97 correct:
1 integer field = 4 Byte
|
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 tables are?
TIA
ron
|
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 in size, while the backup files that I had saved few days back were 258
MB in size.
And the network drive is where the database is saved on.
Can anyone suggest something why or how I can track what happend or a way to
|
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 inserted and updated is coming from a
remote db. The mdb file size is normally around 80MB but since running the
vb.net app the mdb file size grows to 1GB or so every few days. After
compact and repair the size does get back to 80MB but it is still a...
|
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 keep track of the
memory which is used for each object (for stats purpose). They are 2
basic approaches, one is to write a Memory manager type of class where
new & delete would be overloading the standard new & delete operator.
Each time the new...
| | |
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.
|
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 “99012 Large
Address”.
This works fine but when I move my database to another PC (with
identical Dymo printer and drivers) the report defaults to the correct
printer but does not select the label “99012 Large Address”. On
different PC’s it...
|
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 involves databases that I created in Access 2002 (i.e. *.mdb files).
What happens is when I open a form that has the border style property set to 'Dialog', Access 2007 is correctly preserving the size of the form itself (i.e. if you look in the...
|
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 integrity of the DB yet
let me overcome the size limitation.
Is there any best practice or technique?
|
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 array, so im
inputting the dimensions of those myself.
The problem is that the output array (C=A*B) has as many rows as A and
as many columns as B. I would think of initialising C with:
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
