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-06-28 : 09:47:15
|
| Sajesh writes "I am using SQL Server 7.0.By mistake i have deleted some 600 rows from a Table.i have last night backup. but users have made changes after that in this table.is there a way of restoring these records." |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-06-28 : 09:57:50
|
| I've not made this mistake myself but i think you'll have to restore the previous DB backup and then all backed up transaction logs from after the backup. You can restore up to a specific time if you want to be very precise. BOL will probably give you exact syntax's to use.Paul |
 |
|
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
Posted - 2002-06-29 : 06:49:02
|
| Try Lumigent's Log Explorer, its funtastic tool to use.But dont know whether works for SQL Server 7.0, its working fine with SQL 2000....You will find this tool on http://www.lumigent.com/---------------------------Sandesh - The Messanger |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-07-01 : 14:08:25
|
| Lumigent's Log Explorer, is indeed a cool tool. However, if your log has been automatically truncated (trunc. log on chkpt. option) then you may be SOL on it and only have the Restore from Backukp option.Let me just put a plug in here that this is a good time (once you've recovered) to research all of the Backup/Restore options and how different settings (like trunc. log on chkpt.) affect your ability to restore. |
|
|
|
|
|
|
Restoring Deleted Records.