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-03-20 : 09:46:56
|
| Ignacio writes "Please any body help me to recover deleted records from a Sql Server 2000 table.We don´t have a backup.Is there any way ?Thanks." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-03-20 : 09:54:32
|
| You may be able to bring them back with Log Explorer from Lumigent. A trial version is available on their site:lumigent.comAnd start taking backups from now on!!!Edited by - izaltsman on 03/20/2002 09:54:47 |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-03-20 : 10:08:19
|
| If you have a full backup and just haven't taken any log backups for a while you can run a log backup and then restore the database under a different name to a point in time just before the delete. Then you can copy the deleted records from the restored db to the current one. If you have no backups and/or can't afford Log Exporer..... game over man.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
How to recover deleted records from a table