I am deleting a database but I am not seeing any entry in server logs or in event viewer. and same thing is happens when I am deatching a database.
Can any body tell me the way through which I can know when a particualr database was deleted or deatched.
Hi derek3060,
Informatin should be logged to master.ldf when you delete one database from your database engine. Likewise, when you detach a database from a server, same information should be logged to the database's ldf file. However, ldf file is designed to be used by sql server system only and we have no way to read/write file(microsoft does not supply such an approach).
As a work around, i would suggest you try sql server profile. You can create a new trace with sql profil, set up some filters, then all the delete database\detach database behavior will be logged (if you do want to log those behaviors)
Hope my suggesiton helps
|||Yes surely your suggestion has helped.Thanks
No comments:
Post a Comment