Tuesday, March 27, 2012

Database History Info

Is there a way in SQL Server to check when the database was deleted?
Lito D
I would say most likely not. The files are deleted and the entry is removed
from sysdatabases.
However...
In msdb you can check the backup history. Table msdb.dbo.backupset holds
the records of all backups. If a database was dropped without deleting the
backup history (and the database was being backed up!) then you can find
when the last backup happened and infer the deletion date from that.
RLF
"LITO" <anynomous@.msn.com> wrote in message
news:F1C14E2A-6781-4C5E-818F-CDA3D19B30B4@.microsoft.com...
> Is there a way in SQL Server to check when the database was deleted?
> --
> Lito D

No comments:

Post a Comment