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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-24 : 08:36:10
|
| Lai writes "Hi. I got serious problem that 2 tables were removed without any notification. Anyway to trace who or system removed the tables and solution to recover.Many thanks" |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-24 : 13:32:37
|
| "Anyway to trace who or system removed the tables"Not really. You could use a 3rd party tool to read the Log file, but that's about it."solution to recover"Restore an appropriate backup (i.e. from before the deletion) to a new temporary database. Script the Tables out and run that script on the "live" database. Transfer any data with DTS, if necessary.If you are running Transaction Logs you can record to a specific moment in time (just before the Drop/Delete) otherwise you will have to recover to the latest backup before the Drop/Delete occurred.Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-25 : 01:33:45
|
| Were there temporary tables or permanent tables?If they were temporary tables, then they were dropped after the scope where they were createdOtherwise, If you run Profiler before dropping of tables, you can know who deleted themAlso referhttp://vyaskn.tripod.com/sql_server_security_best_practices.htmMadhivananFailing to plan is Planning to fail |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-01-25 : 22:46:59
|
| to recover, restore a backupif no backup file, restore from the transaction log file (if recovery model in full) through a log reader (third party tool)--------------------keeping it simple... |
|
|
|
|
|
|
table missing