SQL Server Performance

Killed SPID

Discussion in 'SQL Server Log Shipping' started by sureshtp2sureshtp2, May 17, 2005.

  1. sureshtp2sureshtp2 New Member

    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.
  2. simondm New Member

    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???

  3. satya Moderator

    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.
  4. sureshtp2sureshtp2 New Member

    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.
  5. satya Moderator

    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.

Share This Page