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 |
|
Inzo
Starting Member
1 Post |
 Posted - 2008-05-28 : 08:17:23
|
| Good day. I am a non-programmer but one tasked to "check" on the recent error in our company's systems.In summary, most, if not all Tables were deleted from the different databases. Add to that, the logs prior to the event were also lost or deleted. Yes we do have back ups but restoring wasn't that simple. Another domain server was corrupted causing further delays in the restoration.This is the second time it has happened and the events were 31 days apart. We would like to identify the causes for our preventive actions. Is there a hardware/software problem that may have caused these? Of course, we would like to rule out that it was done intentionally... but if you guys think otherwise, i'd like to further ask how we can validate the theory.Thank you very much...Inzo |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-28 : 12:50:40
|
| I doubt that this is a data corruption issue. Data corruption is when one of the DBCC commands, such as DBCC CHECKDB, returns errors. Is that the case in this database? If not, I'll move the thread to a more appropriate forum.Is user access locked down? How many people have sysadmin inside SQL Server or db_owner in the database? Do you trust them? Does anyone in your organization have enough experience to run SQL Profiler to capture who/what is causing this?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
|
|
|
Missing Tables and Logs