SQL Server Performance Forum – Threads Archive

Killed SPID

Hello, I am performing log shipping.when I am trying to restore a database on secondary server
by replace option, if found that the database is in use then i killed the spid , but I found that the spid is in rollback satus for the past 3 hrs. Is there any other way to release the locks on that database soon, for making restore successful.
Thanks in advance.

As far as I know you will just have to wait until the rollback has completed. It is a little strange though because your DB should be in read-only mode (because it’s the secondary), so no SPID’s should have been able to change anything???

As it is on secondary server, I wouldn’t worry much and drop the database simply and then restore from previous good backup to continue the log shipping. I think the log shipping may fail once the process is reconfigured. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hello, Even when I tried to remove the database, it is showing the message "Cannot be removed ..the database is in use". So I recycled the sql server and the problem is resolved and note that if the database is in exclusive use we can’t able to drop the database. Even when we try to take the database to be in offline, the alter database cmd will n’t succeed. Regards
Suresh.

Agreed and this is a final solution of restart of SQL services if no other option is working out. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>