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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-06-17 : 14:26:32
|
| Hello, I performed a malicious update to 2 tables during development. I do not do any transaction log backups - db mode = simple recovery.This db is backed up once a day.Is there any way I can get just 2 tables from the db backup file without restoring entire db.I am curious, I read Restore Object (BOL) to restore single unit from db log but I haven't understood the concept or process. -Sarat. |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-06-17 : 16:07:45
|
| You can't. Restoring "Single Unit of Log" has nothing to do with it (basically it just means that if you had log backups, you would have been able to restore them using the Restore object)...The smallest portion of the database you can restore on SQL2k is a filegroup. And I think partial restore wasn't available at all on SQL7. So if your entire database resides on the primary filegroup, or if you are running SQL7 you will have to restore the entire db to a new location, and then DTS your tables back. If you have multiple filegroups, you can restore just the filegroup where the affected tables live (primary filegroup will be restored as well automatically) to a new location, and DTS the data back. Here is how you do a partial restore:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_71f7.aspEdited by - izaltsman on 06/17/2002 16:08:50 |
 |
|
|
|
|
|
Can we restore just a table from backup?