What to do when a Database Delete happens in MSSQL
I recently had a situation where 3 database deletes happened with no one taking ownership of having done the deletes. Some important things that you should back up are:
- The Master database.
- The log folder for that instance of MSSQL. It contains some trace files (extension trc), the SQL event log files and the SQL error logs.
- All of the windows event logs