I want to know if there is a way to revover the state of a database at a certain date. Unfortunately I don't have a backup.
Asked
Active
Viewed 3,005 times
0
2 Answers
11
Without backups of any kind, there is nothing you can do - since previous state has been wiped away by checkpoints (even in full recovery, it acts like simple recovery until you've bothered to take a backup). This situation is precisely what backups are for. If you jump out of a plane without a parachute, don't bother looking for the ripcord...
Aaron Bertrand
- 272,866
- 37
- 466
- 490
-
i KNOW THERE I A WAY TO OPERATE WITH LOG SERVER IN ORDER TO RECUPERATE SOMETHIG. iS IT WRONG?? – Simone Spagna Feb 03 '13 at 20:00
-
4@Simon sorry I don't understand your question. Also please stop yelling. – Aaron Bertrand Feb 03 '13 at 20:39
1
As Aaron said above there are very few things you can do here.
Why do you need to recover database to a previous state? If you deleted some data and want to undo transactions you can probably recover some data if your database was in full recovery mode.
If this is the case you can try reading transaction log using SQL Log Rescue or ApexSQL Log
Mark Davidson
- 414
- 6
- 4