Create Database with 2 filegroups and...

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 ?
ThanksIt 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, unders
tand it and test.
You cannot restore only that table into the original database, not to an ear
lier point in time
(before the accidental delete). This is because you need to apply all transa
ction 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@.microsoft.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