SQL Server : EMC Legato NetWorker :Stop Archiving and Resolve high CPU utilization

As it is primary responsibility of production DBA to validate if daily backup jobs are running successfully if backup is happening via Database Engine or query msdb database to check if backup ran fine if configured via any third Party tool.

In my case, Backup is happening via Database engine but due to space crunch file is being archived to tape on daily basis in order to ensure that we have valid backup in safe location if next backup job failed and we have deleted the older one.

All was working as expected for long time but with time progress, we frequently come  across the situation where archiving started taking long time.

This time, weekend job failed to backup due to space crunch on underlying mount point and space crunch occurred cause archiving process seems in hung state.

In order to resolve above said issue, in EMC Legato Networker, follow the below mentioned steps to stop the archiving process and delete the older backup file to ensure , there is sufficient space for next backup.

Steps:

1. GO to Task Manager

2. Sort processes by name

3. Point all save.exe and kill each process

4. Delete the backup file

In my case , i found 2 processes named save.exe so after killing both , i was able to delete the older backup file.

Now, Next backup can be performed.

Brgds,

Chhavinath Mishra

Database Administrator

Microsoft Certified IT Professional (MCITP)