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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-02-14 : 09:06:21
|
| i lost a table with lots of data - there's around 10,000 records inserted daily.my problem was i only realized this morning (and i lost it last night) and i have the backups backing up each day every hour - so the backup had already overwritten it seems the db that was missing the table)my backup type is set to append - so i though i could retrieve by date time but it only let me retrieve the backup at 11pm(tune if last backup) and no earlier time. is there anyway of getting the data from the 7 pm backup -- again it backsup each hour to the same file - set to append so i thought that meant i could choose a time but it doesn't seem to be working.please advise. |
|
|
recontrasalo
Starting Member
12 Posts |
Posted - 2008-02-14 : 13:25:46
|
| You can't recover point-in-time if you restore from a full backup. |
 |
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-02-14 : 17:12:55
|
| Can you restore the database to another database name and then just copy over the table that you want?Chris Shawwww.SQLonCall.com |
|
|
|
MuadDBA
628 Posts |
Posted - 2008-02-15 : 12:03:03
|
| Are you using the default backup screen? If so, try choosing "backup from device" and then select your backup device, and then use "show contents" to select your desired backup. Are you doing full backups every hour or are these transaction log backups? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-15 : 23:51:33
|
| Ues 'restore headeronly' to find out all backups in backup file, then choose correct one to restore. |
|
|
|
|
|
|
help retrieving from a backup