Transaction Log

[m3ckon]

Can someone please help me ... the transaction Log on my database is
getting ridiculously large and I'm at a loss as to what to do??

The Db in question is in SQLServer 2000 and is on a web server. The data
in the database is sent new data from access on a 15 minute basis from
our company (the access mdb is uploaded then imported using the DTS)

Because of this, the log file in SQL Server is growing at an alarming
rate and I neeed to get it down.

The data is only 110mb whilst the log file is currently at 7 gig

Please help??

M3ckon


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Simon Hayes]

Re: Transaction Log

m3ckon <anonymous@devd ex.com> wrote in message news:<40fb9833$ 0$16451$c397aba @news.newsgroup s.ws>...[color=blue]
> Can someone please help me ... the transaction Log on my database is
> getting ridiculously large and I'm at a loss as to what to do??
>
> The Db in question is in SQLServer 2000 and is on a web server. The data
> in the database is sent new data from access on a 15 minute basis from
> our company (the access mdb is uploaded then imported using the DTS)
>
> Because of this, the log file in SQL Server is growing at an alarming
> rate and I neeed to get it down.
>
> The data is only 110mb whilst the log file is currently at 7 gig
>
> Please help??
>
> M3ckon
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]

http://support.microsoft.com/default.aspx?scid=kb;en-us;272318&Product=sql2k

Simon