Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: find transaction that generated 4 Go in journal file

    We are using SQL Server with logshipping.

    I noticed in the last two days the presence of 2 bigs journal files
    (about 2Go each, transfered from primary to secondary ).

    I want to know if there is a way to see what was the operation that lead to have this to big 2 log files
    (sql statement or transaction... : with Oracle for instance, if we have chance, we can find this kind of info in
    a dynamic views by the name of : v$sqlarea...)...

    Thanks in advance

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    I don't think you can do this without a third party tool, such as the Lumigent log explorer. I'm not even sure what that can do with log shipping, but it is where I'd start.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts