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 |
|
davidhills
Starting Member
14 Posts |
 Posted - 2010-11-29 : 09:58:58
|
| Good MorningIf I do a full backup every day, but for some reason the last two full backups are not available, is there anyway to recover, if I have all the differentials.thanksdavid hills |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-29 : 10:02:51
|
| Depends.A differential needs to be applied to the last full backup.If the full backups were taken and are now lost then the differentials taken afterwards are useless.If you are taking tr log backups and have a sequence since any full backup then you can apply those.If you have lost the fulls and aren't taking logs then you are stuck with the last full you have and the last diff before the next full. That will be the latest you could possibly restore - if they work.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Missing Full Backups