Home Forums SQL Server 2014 Administration - SQL Server 2014 Kill long running transactions RE: Kill long running transactions
Ivan R.
SSChasing Mays
Points: 628
More actions
February 8, 2018 at 8:14 pm
#1979159
agree a service 1bounce sometimes does work; when it does not the DB goes to recovery mode and you wait again, but usually this is no longer the 20 hours elapsed you mention.