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.
| 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 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
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. |
|
|
|
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. |
|
|
|
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... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-08 : 13:15:53
|
| Has insert trigger on the table? |
|
|
|
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 |
|
|
|
|
|
|
|
|
Tables Emptied and No Logs to Recover Them!