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.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Tables Emptied and No Logs to Recover Them!

Author  Topic 

Zenith
Starting Member

2 Posts

Posted - 2007-08-06 : 11:00:39
Greetings,

I got severe data corruption issue today when I copied a SQLServer2000 database from our remote server to my local PC through enterprise manager. The new copy on my local PC did not have any records in the user tables, and when I looked at the remote server, the records gone either with only table skeletons and procedures there. The mdf file on the remote server is emptied at all, but that on my local PC still has 50MB. I think there are data in this file, but the ldf log was also emptied, but I cannot recover it -- I do not have backup and the ldf file was also emptied.

I ran checkdb, and it did not tell any error but show that all the user defines tables has zero records.

I wonder whether there is now any way to recover the data. They are important and I really dont want to lose them.

Thanks in advance!

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-08-06 : 11:39:08
you probably already lost them...

how did you exactly copy your data from production to your server?


_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2007-08-06 : 11:48:54
Doesn't sound like a data corruption problem.
If you haven't taken a full backup the the log will be truncated - it wouldn't be any use even if it wasn't.

Think you have lost the data.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-06 : 12:06:32
If logs are not truncated, you can recover them with third party tools.
Go to Top of Page

Zenith
Starting Member

2 Posts

Posted - 2007-08-08 : 01:14:15
Thank you all. Yes I also found it is impossible now to get the data back.

I did the copy with Enterprise Manager's "All Tasks/Export Data" on the remote server to my local PC. When it was first imported, the data were there in my local PC, however after I did some insertion operation (they should be safe operations), I suddenly found that the data gone. Then I looked at the remote server, surprisingly, the data there had gone too.

I wonder how all that could happen...
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-08 : 13:15:53
Has insert trigger on the table?
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-08-08 : 13:50:46
quote:
Originally posted by Zenith
...I wonder how all that could happen...


A thousand different things can go wrong to mess up a database.

The real problem is that you didn't have any backups.



CODO ERGO SUM
Go to Top of Page
   

- Advertisement -