Wednesday, August 28, 2013

log file in sql server 2008?

It would be incredibly hard to find out who deleted it by going through log files.


The best thing you can do is to restore your last backup and copy it from there back into your database.


Once that's done then add a trigger to your database (DDL trigger) in order to track anyone dropping any objects.


No comments:

Post a Comment