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 |
|
SQLDiva
Starting Member
26 Posts |
 Posted - 2003-01-27 : 17:59:21
|
| Our situation is outlined below. Our architecture is such that we backup our databases and move them to an FTP server where the network admin will then (supposedly) back them up onto tape. He has not done that part of the schema, and we've lost a database.Here is what we do have.We have a differential backup, without the matching full backup. Is there a way to restore against a different full backup of the same database. If this will not work, is there any way to restore the data from the differential in any way. We are aware that if there is a way to do this, the data will not be ... optimum. But there is one table we HAVE to have. Any ideas as quickly as possible would be great.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-27 : 18:20:24
|
| Without the full backup, you will be unable to restore the differential backup. The differential backup would only contain changes since the last full backup anyway, so if that table that you just have to have hadn't changed, then the table wouldn't even exist in the differential backup. |
 |
|
|
SQLDiva
Starting Member
26 Posts |
Posted - 2003-01-27 : 18:26:19
|
| We have a full backup from a week before and a few days after. The problem is that the backup the differential is based on is gone. The table exists in all the backups we have, minus the changes that are represented in the differential. The tables will be exactly the same in the full backups we're missing and the one we have. We want to restore the differential to get the changes that were made in the tables on production. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-27 : 18:27:49
|
| The only way to recover that data would be if you were backing up the transaction logs as well. You could then restore your database on another server, restore it to a point in time, extract the data, then copy the data over to your production server. What is your recovery model set to on this database? |
|
|
|
|
|
|
Out of sequence Differential backups