Find Last Database Backup Time Stamp

 

Use the SQL script below to find your last database backup time.

 

SQL Query:

 

Use Master

Select (SubString(Database_Name,1,32)) 'Database Name',

Backup_Finish_Date 'Last Backup Time Stamp'

From Msdb.Dbo.Backupset

 

 

Published Sunday, October 28, 2007 8:38 AM by dhite
Filed under:

Comments

No Comments