sql server 2000- script to check when the databases got backedup?

• sqlguy80

  SSCrazy

  Points: 2765

  More actions

  May 31, 2017 at 9:14 pm

  #402115

  Any way to check when all databases got backed up on  a SQL Server 2000 instance?

• andreas.kreuzberg

  SSCertifiable

  Points: 6191

  More actions

  May 31, 2017 at 11:26 pm

  #1944848

  Hi,
  do you realy mean sql server 2000?

  On the sql server 2016 you could use something like this:

  SELECT * FROM backupset

  There are many information, and the last backup date.

  Kind regards,

  Andreas