July 1, 2008 at 10:11 am
Hi,
I want to know if there's any chance on recover data wit this conditions:
- Didn't do a backup
- Erase data from a table.
- Did a backup after
Can i recover the data without he bak file?
Is there any chance?
Sql Server 2005 express
Thanks,
Pfs
July 1, 2008 at 10:37 am
No. Shows the importance of full backups on a regular basis. You could've then at least done a log backup and re-played it to a point in time, provided your database is not set to simple recovery.
-- You can't be late until you show up.
July 1, 2008 at 10:46 am
The database was planned with full backupd dairly but with no explanations, the automatic windows task was disabled without my knowledge.
Bottom line, i just can restore until 11-06.
Thanks,
regards,
Paulo
July 1, 2008 at 10:46 am
Is the database in full recovery mode? You could get a log reader from Apex SQL or Lumigent
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply