Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cshah1
Constraint Violating Yak Guru
347 Posts |
 Posted - 2005-05-16 : 11:16:21
|
| Is there any built in procedure to know last time the database has been backed up? |
|
|
monkeybite
Posting Yak Master
152 Posts |
Posted - 2005-05-16 : 12:00:56
|
Not that i've found. I use this script to get the backup set completion dates for a database:SELECT [backup_finish_date] FROM [msdb].[dbo].[backupset] WHERE TYPE = 'D' AND [database_name] = N'master'ORDER BY [backup_finish_date] DESC ~ monkey |
 |
|
|
|
|
|
Last Backup time