Home Forums SQL Server 2005 Administering Is there any way to flush out a stuck process in sql server RE: Is there any way to flush out a stuck process in sql server

  • Thanks for the response Chirag.

    I don’t know where you are getting confuse, anyway let me explain again. I have a scheduled database backup job everyday at 22:30 it works fine but some time (usually once in a month) we found that its keep executing - reason being there is another process "SQL DMO" is taking backup for the same database. I have killed both the processes but they are in killed/rollback mode (not getting flush)

    Now i have two questions:

    1.) Is there any way to flush these processes without restarting SQL services?

    2.) Can we find out from where the another process (SQL DMO) has been initiated and who started it etc.

    Thanks,