| Tibor Karaszi 2005-07-28, 8:23 pm |
| It depends on what you want to achieve. You can restore only that table to a new database and copy
the data into the original database. See the PATRTIAL option of the RESTORE command. This is an
advanced feature, make sure you read the information in Books Online, understand it and test.
You cannot restore only that table into the original database, not to an earlier point in time
(before the accidental delete). This is because you need to apply all transaction log backups up to
current point in time, so the delete will be applied.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Mônica" <Mnica@discussions.microsoft.com> wrote in message
news:5CF5BEF7-0E67-4AC9-AFC3- 2F37B9512A14@microso
ft.com...
>I create one table on each filegroup, for example:
> Database mywind
> file1 = mywind_data_1
> filegroup1= new_customers
> file2 = mywind_data_2
> filegroup2 = sales
>
> Then the t1 table is created on new_customers and the t2 table is created on
> sales.
>
> If I delete t1 I can restore only this table ? Using one backup from
> filegroups?
> I can restore only this table ???
>
> Thanks
|