Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • Reply To: XACT_STATE(), @@TRANCOUNT and ROLLBACK

    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:

  • RE: Restore

    doug.davidson (9/30/2015)


    Just my 2 cents.

    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...

  • RE: Restore

    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...

  • RE: Restore

    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...

Viewing 4 posts - 1 through 4 (of 4 total)