I think your case is about distributed transaction (linked server). If so, about your case, I think a restart is needed to complete the rollback.

I guess, the...

Technically, yes, you can do it. Basically, you are welcome to pay, anytime.
But as Phil mentioned, you should check if you use any enterprise feature. If yes, you need...

CAL is still alive?? Very, very curious.

I'm pretty sure it's AWS credentials issue. I guess you use SAML/IAM Role to generate temp credential. MSSQL works in different security context. Means it can NOT use your credential. You...

Check if you have 'VIEW SERVER STATE' permission.

I'd ask why you need to do this. Two or three years ago, I was asked to do it because the hardware is out of warranty. Since there are lots...

Administrator is not enough. You need to check the installation log to find details. Generally, you need to change some entries in security policy, such as debuguser, etc.

If you kill active transaction, MSSQL does need rollback to guarantee the data consistence. I think it's lesson. Whenever we kill a session, first of all, we should be very...

If your DB is so big, I think you need to think about re-designing File/File group (or split it to multiple relatively small DBs). Then you can just backup one...

Replication should be OK.

Any one know how we can get a full db backup using any tool available? 
>> I think it's still possible to get a full DB backup. It depends on...