Sunday, March 11, 2012

database disappeared from SQL 2005

Hi
One of my database disappeared from SQL 2005.
Maybe my mistake (i dont remember) or some SQL problem... or..
something else.
Is there a way (logs, etc..) to see when database was deleted?
Thank YouJohnZing wrote:
> Hi
> One of my database disappeared from SQL 2005.
> Maybe my mistake (i dont remember) or some SQL problem... or..
> something else.
> Is there a way (logs, etc..) to see when database was deleted?
> Thank You
If the default trace is enabled take a look at the trace file.
Typically it is in the folder \Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG. Search for the Object:Deleted event.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

No comments:

Post a Comment