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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment