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

huge logfile problem

guf
Hi All,

I have SQL Server 2000 sp3, Windows 2000 Server.
I have a database which is used by an application server. I do several
important jobs a day in the application server and never access my
database directly. Those jobs are created through the application
server API and I do not have access to the Application server
procedure.

My database is 500 Mo.
Now my problem is that some jobs that are planed through the
application server can generate huge logfile (2 Go+) in less than 20
minutes work.
What is really strange is if I export my db using the DTS, and
performed the same operation on the new database, the logfile don't
grow more than 4 or 5 Mo. If I switch the production database to the
new one, it takes no more than 2 days to have the same problem.

This is a real problem because backup takes longer, and will
probably be harder to restore in case of crash. The operation is also
slowing down the system because SQL Server needs to add more space to
the logfile.

I cannot switch easily from one database to another, because this is a
production application and we should have 99,99% availability.

Jobs that are planed in my database:
On an hourly basis:
* logfile backup

On a daily basis:
* database backup
* DBCC SHRINKDATABASE (N'IMANDATA', 30,TRUNCATEONLY) every day
* EXECUTE master.dbo.xp_sqlmaint N'-PlanID XXX -Rpt "f:\...."
-DelTxtRpt 2WEEKS -WriteHistory -RebldIdx 10 '
* EXECUTE master.dbo.xp_sqlmaint N'-PlanID XXX -Rpt "f:\...."
-DelTxtRpt 2DAYS -WriteHistory -UpdOptiStats 100 '
* EXECUTE master.dbo.xp_sqlmaint N'-PlanID XXX -Rpt "f:\..."
-DelTxtRpt 2WEEKS -WriteHistory -CkDB '

It would be really great if someone could help me on this.

guillaume
Jul 20 '05 #1
0 1771

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

Similar topics

0
by: guf | last post by:
Hi All, I have SQL Server 2000 sp3, Windows 2000 Server. I have a database which is used by an application server. I do several important jobs a day in the application server and never access my...
4
by: Sebastian Luemmer | last post by:
Hi, when I had a look at my monthly webserver logfile, I found several strange requests for files, which are definitely not on my webserver. These files were /_vti_inf.html...
1
by: FJ | last post by:
Hi all, I hope someone can help me with the following: I want my database to make a logfile in which it puts the date and time a code is used. The code is triggered by a timer. Every x mins it...
6
by: Daniel Walzenbach | last post by:
Hi, I have a web application which sometimes throws an “out of memory” exception. To get an idea what happens I traced some values using performance monitor and got the following values (for...
2
by: ge_orgy | last post by:
Accidently, I(we) deleted the Logfile.LDF in sysfiles folder on the mssql server and now can't enter the database, which status now is set SUSPECT. Before deleting the logfile I did a...
2
by: Andi Clemens | last post by:
Hi, we had some problems in the last weeks with our mailserver. Some messages were not delivered and we wanted to know why. But looking through the logfile is a time consuming process. So I...
6
by: roger.lagrilliere | last post by:
Hello, is anyone willing to help me out to setup a logfile. I have a program running in Access, but I want to know the progress of it. It is rather easy I think, but don't know how to handle...
0
by: Adam | last post by:
Hello, I have a small app I am creating to crawl a directory and check that if it is moved to another a location it's path will not break a character limit. Usually the Windows path limit. ...
2
by: pompom | last post by:
hello all! i have to make a project for school , making a newsserver and a client. the thing is, i send messages between them to let the user know if everything is running ok. just some simple...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
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,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
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
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...

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.