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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-15 : 10:48:24
|
| Carl writes "I have a SQL 2000 database that appears to have reverted to a primitive state. All of my tables are empty, and several of them have reverted to previous incarnations of my schema. Quite a lot of recent work is MIAI looked at the .mdf file with an editor, and I can see the data recently entered is there in the file - SQL just isn't showing it! I can't be the first person this has happened to...I have the .mdf and .ldf - the file was in simple recovery mode. How can I convince SQL to show me all of my data?" |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-11-15 : 11:14:53
|
Could it be your query? Try do detach your database and to attach it after. Never seen that before! have you tried to restore you db from your backup? |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-11-15 : 11:42:08
|
| You could also try re-installing the enterprise manager if you haven't already ?===========Paul |
|
|
|
carle
Starting Member
1 Post |
Posted - 2002-11-15 : 12:25:46
|
| None of that is it. I tried doing a restore log last night, and the system told me the log file terminates with an LNS that is too early for the database.It said to go find a log file with the later LNS in it, but I know for a fact that I do not have such a file. |
|
|
|
|
|
|
My database has gone back in time!