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)
 Dropped DB logging

Author  Topic 

steel
Posting Yak Master

107 Posts

Posted - 2009-04-27 : 04:46:32
Hi All,

I have a production system on sql2k + sp4 and found that one of the databases is dropped on the server.Does dropping of a database is logged on to the logs or some where stored in the master database tables??


Please help its urgent....

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-04-27 : 11:53:50
Nope. Unless you had a trace running at the time (profiler or server-side trace), there's no way to tell who dropped it and when.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -