The Last Valid Restore Time

• Steve Jones - SSC Editor

  SSC Guru

  Points: 730291

  More actions

  December 2, 2022 at 12:00 am

  #4116151

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

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com

• Jeff Moden

  SSC Guru

  Points: 1002113

  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.

  Dear Lord... I'm a production DBA. Please grant me patience because, if you grant me strength, I'm gonna need bail money to go with it.
  

  ---

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