Cannot Kill SQLServer Backupprocesses after Networker failure.

[BramdeJager]

Hallo Techies around the world, after a failure of Networker backing up a SQLServer 7.0 database, the remaining backup processes are still running. They must be killed in order to start a new backup cycle.
The next message is appearing :

ns2309:MSSQL: nsrsqlsv: MS SQL Server v7.0 reports Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.

With SQLServerManager i can see the Backup processes waiting
but i cannot kill them, although it must be possible when i am logged in as the database administrator.
There are no old save processes.

Any suggestions?

Bram de Jager.

 

[MoshiachNow]

Hi,

Have you tried "kill -9 PID" ? "Long live king Moshiach !"
h

http://www.noahide.com/movement.htm

 

[StefanS]

On your SQL Server, open taskmanager and check if there is any process instance of "nsrsqlsv.exe" still running. If so, kill it using "kill.exe". Then the backup process in SQL Server should die.

Regards,
StefanS