Viewing 4 posts - 1 through 4 (of 4 total)
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)
database crashed and it should be restored with minimal data loss using existing files
Option 3 is faster, you are losing data every second after the crash...
September 30, 2015 at 1:01 pm
SQLRNNR (9/30/2015)
Hugo Kornelis (9/30/2015)
September 30, 2015 at 10:41 am
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...
September 30, 2015 at 10:35 am
Viewing 4 posts - 1 through 4 (of 4 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy