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 |
|
jai2808
Starting Member
27 Posts |
 Posted - 2009-10-10 : 05:37:46
|
| Hi,Accidently i deleted some records from database.There was no regular backup scheduled.Once deleted, then i took backup of the database.Can i restore the deleted records from log file.Thanks,JP |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-10-10 : 05:47:59
|
No.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-10 : 08:29:55
|
| You need a backup taken before the delete (full database backup) and the log backups from that full backup up to the point just before the delete. That's if the DB is in full recovery. If the DB is in simple recovery, then log backups cannot be done, inactive log records are cleared on a regular basis and to recover anything you need the full backup taken before the delete.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Recover Deleted Records