How database table called “service group” disappeared

Asked By Roland Guadalupe 0 points N/A Posted on - 11/14/2011

I want to know how the database table called “servicesgroups” disappeared from the SQL Server database. It can select, delete and update without having a “drop table” statements. I also use ASP.NET application. The sites are installed with SQL 2005 express, Standard or Enterprise on a Windows Server 2008 OS.    

• Status: Open
• Question Views: 973
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Misc Databases

Best Answer by SARA U

Go To Solution

Best Answer

Best Answer

Answered By SARA U 10 points N/A #109164

How database table called “service group” disappeared

Roland Guadalupe

Hi,

Look there cannot be an issue that a particular table or record disappears automatically.

Either it will be a complete data corruption in the SQL, which can be checked by running the command

DBCC CHECKDB, and I am sure you will find NO errors,

OR, it is a deliberate delete of a table by some user.

A point to note, if you want to tweak your SQL tables and queries, I suggest you should visit this site

https://dzone.com/articles/how-to-optimize-mysql-queries-for-speed-and-perfor

SARA

About SARA U

Questions
0

Answers
25

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 11/15/2011
• Question Category: Misc Databases

Answered By marsh watson 0 points N/A #109167

How database table called “service group” disappeared

 

You can get you data recovered manually. In order to track the record of the process that is causing troubles and might hiding your database, you can use the log file managed by SQL server using SQL command

SELECT *

FROM fn_trace_gettable

(‘C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGlog_19.trc’ , default).

This will provide you when and who dropped the database.

About marsh watson

Questions
2

Answers
108

Best Answers
65

• Vote Up 0 Vote Down

• Posted on - 12/08/2012
• Question Category: Misc Databases