192.168.0.16  lisans SSL port 8391

1-) YEDEK ALMA

RESTORE DATABASE zaa

FROM DISK = 'D:\zaa.bak'

2-) transcation hatasi alırsan

DBCC opentran() -- spid id sini bul sonra kill yap

kill 56

açıklama

DBCC opentran()

You will get the detail of the active transaction, then from the SPID of the active transaction, get the detail about the SPID using following commands

exec sp_who2 <SPID>

exec sp_lock <SPID>

For example, if SPID is 69 then execute the command as

exec sp_who2 69

exec sp_lock 69

Now , you can kill that process using the following command

KILL 69

I hope this helps :)