How database table called “service group” disappeared

Asked By 0 points N/A Posted on -
qa-featured

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.    

SHARE
Best Answer by SARA U
Best Answer
Best Answer
Answered By 0 points N/A #109164

How database table called “service group” disappeared

qa-featured

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

http://weblogs.sqlteam.com/tarad/default.aspx

.

SARA

Answered By 0 points N/A #109167

How database table called “service group” disappeared

qa-featured

 

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.

Login/Register to Answer

Related Questions