Re: sqlmaint.exe hangs

Sat,

Is the file you are trying to delete locked?

-- Bill

"Satwinder" <Satwinder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FEB4B0AE-EF2E-4FE7-89DB-C4416B8B1A31@xxxxxxxxxxxxxxxx
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..


.

Relevant Pages

  • Re: creating cubes from different data sources Analysis Services 2005
    ... If you think you can synchronize multiple datasources into AS then its ... because your source databases are clean, ... you can't create a cube using different DSV (so no ... another option is to create an empty database in SQL Server and create ...
    (microsoft.public.sqlserver.olap)
  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... In the "Maintenance Plan" node of the log viewer: ... Every entry has a red X next to it. ...
    (microsoft.public.sqlserver.tools)
  • Re: Run job from DTS package
    ... DTS package then you can have the Account under which it runs have perms to ... How do you propose to know that the backup job you have selected comes from ... Which maint plan? ... You may have one for logs and one for some databases, ...
    (microsoft.public.sqlserver.dts)
  • Re: "Field Cannot Be Updated" Error
    ... Unfortunately, based on the underlying rules of databases, you cannot ... update a value in a form (or query) based on a query that draws on ... Table Source: Multiple tables ...
    (microsoft.public.access.forms)
  • Re: Array expert needed! (long)
    ... First rule of databases - normalize your data. ... You should have multiple tables to handle this information. ... 'children' => array() ...
    (comp.lang.php)