Post reply

Log Files

  • May 22, 2014 at 9:41 am

    #1715744

    rhythmk (5/22/2014)

    Thanks for the question Steve.

    However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in SQL Server 2008.

    Fair enough. I've corrected this to 2012. I've been working on 2012 and 2014 only for a few years, so I didn't think about back-checking to 2008.

  • May 22, 2014 at 11:18 am

    #1715790

    nice question steve.

  • May 22, 2014 at 7:02 pm

    #1715922

    The link provided is for 2014 --

    2012 as referenced in the question does not have the same list on MSDN

    http://msdn.microsoft.com/en-us/library/dd206998(v=sql.110).aspx

  • May 22, 2014 at 9:34 pm

    #1715933

    raulggonzalez (5/22/2014)

    thanks for the question,

    but why all answers say "only" at the end?? that's a bit confusing since no option has all the types listed in BOL. :w00t:

    +1

    With the "only" at the end, I think all of the answers are wrong.

    Plus, you can open other log files (.csv, .log files) - although you will need to make sure they have field that the log file viewer knows about

  • May 23, 2014 at 1:39 am

    #1715961

    Steve Jones - SSC Editor (5/22/2014)

    rhythmk (5/22/2014)

    Thanks for the question Steve.

    However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in SQL Server 2008.

    Fair enough. I've corrected this to 2012. I've been working on 2012 and 2014 only for a few years, so I didn't think about back-checking to 2008.

    From the options given I'd have thought it fair to say getting to the correct answer was reasonably easy, so why all the gripes?

  • May 23, 2014 at 9:33 am

    #1716137

    happycat59 (5/22/2014)

    raulggonzalez (5/22/2014)

    thanks for the question,

    but why all answers say "only" at the end?? that's a bit confusing since no option has all the types listed in BOL. :w00t:

    +1

    With the "only" at the end, I think all of the answers are wrong.

    Plus, you can open other log files (.csv, .log files) - although you will need to make sure they have field that the log file viewer knows about

    Yes, a nice and easy question. The "correct" answer is actually the least incorrect option. Replacing the word "only" by "and more" in that option would make it actually correct.

    Tom

  • May 24, 2014 at 7:35 am

    #1716308

    If all mentioned files types mentioned in the answer are correct plus the database mail & local Maintenance plan logs; then the word "Only" is incoreect here 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • May 24, 2014 at 7:36 am

    #1716309

    TomThomson (5/23/2014)

    happycat59 (5/22/2014)

    raulggonzalez (5/22/2014)

    thanks for the question,

    but why all answers say "only" at the end?? that's a bit confusing since no option has all the types listed in BOL. :w00t:

    +1

    With the "only" at the end, I think all of the answers are wrong.

    Plus, you can open other log files (.csv, .log files) - although you will need to make sure they have field that the log file viewer knows about

    Yes, a nice and easy question. The "correct" answer is actually the least incorrect option. Replacing the word "only" by "and more" in that option would make it actually correct.

    + True.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 8 posts - 16 through 22 (of 22 total)

You must be logged in to reply to this topic. Login to reply