473,395 Members | 1,969 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,395 software developers and data experts.

Log file of test database bloating

A test database that we used in one of our implementation pilots was
abandoned around 4 months back. The database when abandoned had a log
file size of less than 500MB. The log file has been steadily bloating
(just came to my attention) and has reached 8.5GB. The database has
not been used since abandoned 4 months back at 500MB. Considering the
fact that our live DB has a combined (data + log) file size of less
than 2GB I do not want to delete the database before exploring the
cause.

Any ideas??? Thanks and appreciate your help

SQL Server 2000
Jul 20 '05 #1
1 1830

"Sanjay Asrani" <sa*****@boathouse.com> wrote in message
news:26**************************@posting.google.c om...
A test database that we used in one of our implementation pilots was
abandoned around 4 months back. The database when abandoned had a log
file size of less than 500MB. The log file has been steadily bloating
(just came to my attention) and has reached 8.5GB. The database has
not been used since abandoned 4 months back at 500MB. Considering the
fact that our live DB has a combined (data + log) file size of less
than 2GB I do not want to delete the database before exploring the
cause.

Any ideas??? Thanks and appreciate your help

SQL Server 2000


This might be useful:

http://support.microsoft.com/default...b;EN-US;317375

If you believe the database should not be in use, you might want to run a
Profiler trace filtered on that particular database to see what's happening.

Simon
Jul 20 '05 #2

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

Similar topics

11
by: Andante.in.Blue | last post by:
A recent change in the user interface of one of the tech forums I frequent prompted furious debates in the areas of functionality versus look'n'feel of professional applications. This has made me...
13
by: Larry L | last post by:
Access is noted for bloating a database when you add and delete records frequently. I have always had mine set to compact on close, and that works great. Now after everyone's advice I split my...
4
by: MikeZ | last post by:
Hi, Although I am new to Access, I do try to experiment a bit. although this time I may have gotten over my head. Hopefully someone can help me out. No doubt a simple question for many of you. ...
14
by: Sonic | last post by:
I have an MDE file that is growing exponentially (from 3,900 KB to over 132,000 KB today). I am not saving data in this MDE, although I use a mix of offline and SQL tables for Read Only querying. ...
19
by: jameso321 | last post by:
Hi, We run an MS Access 2000 DB with about 15 users. It is on a Win 2000 Server (SP4) machine and runs through Citrix Metaframe Presentation Server 3.0. --------------------------
12
by: Riley DeWiley | last post by:
I have a project that is using a Jet backend and having trouble with Jet's tendency to bloat it's MDB file. I can compact it but it is a hassle. I am considering switching to a Fox backend but have...
3
by: Henrootje | last post by:
I have a database in which regurlarily tables are being created or deleted. This causes a lot of bloating. I set the property that causes the db to compress and repair at close but my users...
2
by: sloan | last post by:
VB.NET object "bloating" and WCF. //quote from web page This can result in the following undesirable situations: a.. You end up serializing objects that you didn't expect, resulting in a...
4
by: CeeBeeSky | last post by:
I am using Access 2003 but my Access file is in 2000 format. I have deleted some data (some unused customers in the "Customer" table and some old Orders from the "Order" table). I did this to try...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
jinu1996
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...
0
tracyyun
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...
0
agi2029
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,...

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.