Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Tables Emptied and No Logs to Recover Them!
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 08/06/2007 :  11:00:39  Show Profile  Reply with Quote

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!

Cybernetic Yak Master

11752 Posts

Posted - 08/06/2007 :  11:39:08  Show Profile  Visit spirit1's Homepage  Reply with Quote
you probably already lost them...

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

Causing trouble since 1980

Edited by - spirit1 on 08/06/2007 11:39:21
Go to Top of Page


United Kingdom
12543 Posts

Posted - 08/06/2007 :  11:48:54  Show Profile  Visit nr's Homepage  Reply with Quote
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.

Edited by - nr on 08/06/2007 11:49:55
Go to Top of Page

Flowing Fount of Yak Knowledge

7266 Posts

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

Starting Member

2 Posts

Posted - 08/08/2007 :  01:14:15  Show Profile  Reply with Quote
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

Flowing Fount of Yak Knowledge

7266 Posts

Posted - 08/08/2007 :  13:15:53  Show Profile  Reply with Quote
Has insert trigger on the table?
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 08/08/2007 :  13:50:46  Show Profile  Reply with 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.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000