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 |
|
crystal_szeyin
Starting Member
9 Posts |
 Posted - 2007-11-25 : 07:27:05
|
| Scenario: -1. Full db backup2. Database failure (delete all data) 3. Differential db backup (after 3 hour of db failure)When i restore full db followed by the differential db backup, it only remains the differential db data.I do not have transaction log backup so that i can restore to the point. What can i do to restore db that can have full backup and differential backup data? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-25 : 16:16:50
|
| If you need get deleted data back, only way is restore the db from full backup in this case. Can't do point of time recovery without log backup. |
 |
|
|
crystal_szeyin
Starting Member
9 Posts |
Posted - 2007-11-25 : 19:01:03
|
| Currently whenever i restore the differential backup, then the full backup will lost. So i plan to setup 2 db, 1 for full db and 1 for differetial db. But is there any fastest way to copy over the data? The method had to able to copy over the data from differential to full db whenever the data is not exists in full db. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-25 : 19:29:11
|
| Possible if you know what are new after making full backup. |
|
|
|
crystal_szeyin
Starting Member
9 Posts |
Posted - 2007-11-25 : 20:59:20
|
| I hope the method can auto transfer over the new data from differential to full db when the differential data not found in full db. Possible? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-25 : 21:05:27
|
| No since sql never know what you need. |
|
|
|
|
|
|
Restore differential database