You can add SELECT @@TRANCOUNT after the catch block and see whether the transaction is rolled back or not. For a detailed explanation, you can read the following article:

doug.davidson (9/30/2015)

---

Just my 2 cents.

Option 3 is faster, you are losing data every second after the crash...

SQLRNNR (9/30/2015)

---

Hugo Kornelis (9/30/2015)

---

None of these answers are fully correct. To ensure minimal data loss, one should always start by a tail-log backup. (Which will fail if the log file...

I agree with Hugo and Jason, to restore database with minimal data loss we should firstly try to do tail-log backup.

However it's mentioned in the question that "it should be...