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 |
|
leon_irl
Starting Member
8 Posts |
 Posted - 2007-07-18 : 08:01:19
|
| Hi, I needed to delete and restore my database so I did a backup, I used the Append and not the overwrite method. I then deleted the DB but in the process deleted the BAckup and restore History. When I restored my DB it was from the original backup set date..A lot of worked lost..!Is there any way to get the recover my data..?Cheers |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-18 : 12:06:22
|
| Run 'restore headeronly' to get recent backup's file number, then restore with 'file =' option using restore statement. |
 |
|
|
leon_irl
Starting Member
8 Posts |
Posted - 2007-07-20 : 08:40:36
|
| I was having a bad day... i didnt see the option of selecting a previous backup set :(Thanks for your input though. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-20 : 11:06:35
|
| You have to run the statement in query analyzer. |
|
|
|
|
|
|
Deleted Backup and restore History Nightmare