Transaction log backup process hanging

[shaili]

Hi,

My transaction log backup task for the production database which normally takes about 10 seconds has been running for almost about 2 hours now.

Is there any way to stop it without restarting sql services? The scheduled task was stopped from the jobs but spid is still in 'runnable' status. I should not kill 'backup log' or 'xp_sqlmaint' tasks.( It doesn't solve the problem anyway. the SPID goes in rollback status and stays like that until server is rebooted). Any way to find out what causes this problem and how to prevent it?

Thanks,
Shaili

[skhanal]

Do you have any open transaction (a long running one) in the database?.

If yes, then SQL server may be trying to dump everything since that transaction started. Earlier backups could not have truncate the transaction log because of the open transaction.

Also check the size of the transaction log file.

[rmiao]

You can try stop sqlmaint process in windows task manager or restart sql agent service.