SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Zenith
Starting Member

2 Posts

Posted - 08/06/2007 :  11:00:39  Show Profile  Reply with Quote
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

Slovenia
11751 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
blog: http://weblogs.sqlteam.com/mladenp

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

nr
SQLTeam MVY

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

rmiao
Flowing Fount of Yak Knowledge

USA
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

Zenith
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

rmiao
Flowing Fount of Yak Knowledge

USA
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)

USA
7020 Posts

Posted - 08/08/2007 :  13:50:46  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New 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.06 seconds. Powered By: Snitz Forums 2000