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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Where to find Delete Logs

Author  Topic 

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2006-01-13 : 01:22:34
Hi there,

Ive looked in sql logs but cannot find information on when a database was deleted. Does SQL log this? thanks

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2006-01-13 : 10:17:42
Nope. Apparently it is not recorded in the event logs, either.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-01-13 : 10:39:07
You could determine it from backups of MASTER, I suppose [bit arduous, I mean], but as there are no TLog backups on master the "granularity" of the answer would be restricted to the frequency of full backups that you make on Master.

Kristen
Go to Top of Page
   

- Advertisement -