InvisibleMan
asked on
DATABASE SIZE SHRINKING AND LOG FILE QUESTION
Hello all. I have a database that is approx 625 Meg large currently. I am not sure why it is getting so large it was only approx 200Meg about 2 weeks ago. What I did was I dumped the log file and then did a shrink it went from 701 Meg to 625 Meg. One of the tables is very large it has 1.3 million records in it. I know that might be why it is so big. But I was wondering it says in the properties of the database and on the data files tab it says space allocated 624 Meg. Is there any checks I can do to see actually how big the database should be like by the records etc? Any other way to shrink database more?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
All C grades issued are being changed to A grades. InvisibleMan, if you have issue with this, please post a comment in Community Support and I will have another moderator or an admin look at my actions. If the answer didn't work, you should have opted to request a refund instead of accepting an answer which any one of us would have gladly assisted with.
SpideyMod
Community Support Moderator @Experts Exchange
SpideyMod
Community Support Moderator @Experts Exchange
I am in the process of cleaning up the questions for this member as this member has failed to take care of their opened questions
Experts, please leave your recommendations within the next 3 days.
Without recommendations, I intend to come back here on 2/26/2003 and:
Force Accept answer by baulrich
InvisibleMan,
You have 16 opened questions and have been asked to take care of them previously. If you wish to keep your account in good standing, please take care of these questions prior to 02/26/2003.
Failing this, your account will be reviewed by a site administrator at that point. I am posting this in ALL 16 opened questions and have submitted a cleanup request in community support.
https://www.experts-exchange.com/questions/20439569/Need-help-with-creating-a-word-template-and-some-simple-fields.html
https://www.experts-exchange.com/questions/20453889/Making-a-image-or-picture-visible-with-code-Tough-Question-need-a-smarty.html
https://www.experts-exchange.com/questions/20388128/Unable-to-Log-On-to-Provider-SQLOLEDB-1.html
https://www.experts-exchange.com/questions/20343921/GREAT-PLAINS-DYNAMICS-HELP-Integration-Manager.html
https://www.experts-exchange.com/questions/20273575/DATABASE-SIZE-SHRINKING-AND-LOG-FILE-QUESTION.html
https://www.experts-exchange.com/questions/20480517/Crystal-Reports-Sum-Question-on-Amount-Field-Help-Please.html
https://www.experts-exchange.com/questions/20475331/Inputting-Text-into-a-Bound-Dropdown-Control-Help.html
https://www.experts-exchange.com/questions/20409250/Opening-Excel-File-modifying-column-width-then-saving-it-in-VB.html
https://www.experts-exchange.com/questions/20336887/Visual-Basic-Grid-Help-Different-fields-from-different-sources.html
https://www.experts-exchange.com/questions/20327829/How-to-know-what-the-latest-DLL-is-registered-on-server.html
https://www.experts-exchange.com/questions/20324132/Class-Modules-and-VB-Application-Question.html
https://www.experts-exchange.com/questions/20390261/Creating-a-HTML-Email-Feedback-Form-Can-it-be-done.html
https://www.experts-exchange.com/questions/20403544/PDF-Files-previously-on-the-Web-allowed-data-entry-now-it-does-not-Help.html
https://www.experts-exchange.com/questions/20519637/Tab-Pages-Not-Ordering-Right-on-Tab-Page-Driving-me-nuts-Help.html
https://www.experts-exchange.com/questions/20457825/Strange-Issue-with-Datagrid-Refreshing-Help.html
https://www.experts-exchange.com/questions/20428768/Tree-View-Help-Please-with-Tree-View.html
SpideyMod
Community Support Moderator @Experts Exchange
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!