Catalog Views

• mtassin

  SSC-Insane

  Points: 23099

  More actions

  August 24, 2012 at 1:24 pm

  #1529927

  Oops... didn't pay close attention and got Catalog Views and DMVs mixed up.

  Good question... wish I had gotten it correct... heh...

  ---

  
  --Mark Tassin
  MCITP - SQL Server DBA
  Proud member of the Anti-RBAR alliance.
  For help with Performance click this link[/url]
  For tips on how to post your problems[/url]

• SQLRNNR

  SSC Guru

  Points: 281334

  More actions

  August 26, 2012 at 1:49 am

  #1530098

  Interesting question - thanks.

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events

• TomThomson

  SSC Guru

  Points: 104773

  More actions

  September 2, 2012 at 10:01 am

  #1532740

  Good question and answer, but I have a minor niggle about the explanation. Catalog views include sys.database_recovery_status, which includes information (last_log_backup_lsn) about backups, so the statement in the explanation that they don't contain information about backup is not correct.

  Tom