DELETING 100 million from a table weekly SQl SERVER 2000

Hi All

We have a table in SQL SERVER 2000 which has about 250 million records
and this will be growing by 100 million every week. At a time the table
should contain just 13 weeks of data. when the 14th week data needs to
be loaded the first week's data has to be deleted.

And this deletes 100 million every week, since the delete is taking lot
of transaction log space the job is not successful.

Can you please help with what are the approaches we can take to fix
this problem?

Performance and transaction log are the issues we are facing. We tried
deletion in steps too but that also is taking time. What are the
different ways we can address this quickly.

Please reply at the earliest.

Thanks
Harish

.

Relevant Pages

  • Re: HDD still full after shrinking transaction log
    ... So that is the first question: why does the log keep growing? ... In the first case, you should run with full recovery, and backup your ... SQL Server will then truncate the transaction log regularly. ...
    (comp.databases.ms-sqlserver)
  • RE: Transaction Replication, Help!
    ... Total amount of data is about 1 GB. ... >> I have two SQL Server 2000 servers using Transactional Replication with Push ... >> connections" while the subscriber's transaction log file kept growing from ...
    (microsoft.public.sqlserver.replication)
  • Transaction Logs
    ... I have a database with a Transaction log that seems to be growing ... I am new to SQL Server and am looking for a way to ...
    (microsoft.public.sqlserver.msde)
  • Ever increasing transaction log size
    ... The issue I seem to be facing is the fact that the transaction log keeps ... the backup file of the log is only around 900 Mb. ... Can anyone explain to me how and why the log file keeps growing? ...
    (microsoft.public.sqlserver.server)
  • Re: Transaction log and tempdb
    ... - Is it possible to reduce the size of the transaction log fil during ... an execution? ... It sounds as if you are the database is in full recovery. ... If I execute that script sql server seems ...
    (comp.databases.ms-sqlserver)