Post reply

Linked Server and Backups

  • May 21, 2003 at 11:05 am

    #58897

    Can a dormant linked server spid cause a backup to wait?

  • May 21, 2003 at 12:07 pm

    #458018

    Run sp_who2 to see who is blocking your backup.

    Dormant is same as Sleeping, except Dormant also indicates that the SPID has been reset after completing an RPC event. The reset cleans up resources used during the RPC event. This is a normal state and the SPID is available and waiting to execute further commands.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply