"Satwinder" <Satwin***@discussions.microsoft.com> wrote in message
news:FEB4B0AE-EF2E-4FE7-89DB-C4416B8B1A31@microsoft.com...
> We use SQL Server 2000 enterprise SP3 on 2 node active/active cluster
> We have multiple maintenance plans . Single plan contanis multiple
> databases.
>
> One such plan for database txn log backup, takes txn log backup on each
> database sun-directory, writes history & deletes txn log backup files
> older
> than 1 days.
>
> Suddenly this maintenance plan job is hanging. This job is in executing
> state for hours & hours and at last i have to kill the sqlmaint.exe in
> task-manager.
>
> When i check the sysdbmaintplan_history tables it shows all databases txn
> backed & even txn files are created for all databases but plan log files
> is
> stuck at a particular database log.
>
> Basically job hangs after it finishes backup but does not proceed with
> deletion.
>
> I have run this job multiple times but same issue.
>
> New plan for multiple databases also have same issue.
>
> Another plan for few other databases runs fine without any issue.
>
> Can anyone help me on this issue.
>
> Thanks,
>
> Sats..

"AlterEgo" wrote:

> Sat,
>
> Is the file you are trying to delete locked?
>
> -- Bill
>
> "Satwinder" <Satwin***@discussions.microsoft.com> wrote in message
> news:FEB4B0AE-EF2E-4FE7-89DB-C4416B8B1A31@microsoft.com...
> > We use SQL Server 2000 enterprise SP3 on 2 node active/active cluster
> > We have multiple maintenance plans . Single plan contanis multiple
> > databases.
> >
> > One such plan for database txn log backup, takes txn log backup on each
> > database sun-directory, writes history & deletes txn log backup files
> > older
> > than 1 days.
> >
> > Suddenly this maintenance plan job is hanging. This job is in executing
> > state for hours & hours and at last i have to kill the sqlmaint.exe in
> > task-manager.
> >
> > When i check the sysdbmaintplan_history tables it shows all databases txn
> > backed & even txn files are created for all databases but plan log files
> > is
> > stuck at a particular database log.
> >
> > Basically job hangs after it finishes backup but does not proceed with
> > deletion.
> >
> > I have run this job multiple times but same issue.
> >
> > New plan for multiple databases also have same issue.
> >
> > Another plan for few other databases runs fine without any issue.
> >
> > Can anyone help me on this issue.
> >
> > Thanks,
> >
> > Sats..
>
>
>