The Last Valid Restore Time

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737535

  More actions

  December 2, 2022 at 12:00 am

  #4116151

  Comments posted to this topic are about the item The Last Valid Restore Time

• Jeff Moden

  SSC Guru

  Points: 1004567

  More actions

  December 2, 2022 at 6:13 pm

  #4121238

  Good question but...

  The actual correct answer should be... "None of the above because there's no such thing as sys.backupset.  The correct schema for the table is dbo"... unless the coded example they provide is incorrect, which I doubt.  I don't have 2022 yet to verify that they didn't change it from previous versions.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)