Create table on multiple Filegroups .. is it possible ?

Can i create a table/index that spans multilple FGs such as
CREATE TABLE T1
( cola int PRIMARY KEY,
colb char(8) )
ON FG1,FG2,FG3Are you confused between files and filegroups? Have a read in bol about them.
The answer to the question you have posed is no - you have a clustered index
which resides on the data filegroup.
But I don't think it's the question you wanted to ask.
"Hassan" wrote:
> Can i create a table/index that spans multilple FGs such as
> CREATE TABLE T1
> ( cola int PRIMARY KEY,
> colb char(8) )
> ON FG1,FG2,FG3
>
>|||As Nigel says, it isn't possible. Why do you ask? The purpose of
filegroups is to provide a logical entity on which to place data. The
PHYSICAL placement of data is determined by the location of files,
rather than filegroups. So it should be possible to achieve whatever
configuration you need using a single filegroup per object.
--
David Portas
SQL Server MVP
--

Create Database with Filegroups restore Database without Filegroup

I have a SQL Server 2000 virtual server with Austin_Sales as the virtual
server name and REPT as the name instance. This is Active\Active Cluster with
Windows 2000 Advanced Server as the OS.
I have a new server and would like to have filegroups for the database. Can
I create filegroups on the new server and restore the backup from
Austin_Sales\REPT in the database with filegroups?
Please help me with this task.
Thanks,
Restore will give you (essentially) a binary image of what is inside the database. I.e., you cannot
change filegroup layout through backup/restore. You'd have to do that before the backup or after the
restore...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:CFB09E6E-E210-4D53-B26E-98FFAC443E70@.microsoft.com...
> I have a SQL Server 2000 virtual server with Austin_Sales as the virtual
> server name and REPT as the name instance. This is Active\Active Cluster with
> Windows 2000 Advanced Server as the OS.
> I have a new server and would like to have filegroups for the database. Can
> I create filegroups on the new server and restore the backup from
> Austin_Sales\REPT in the database with filegroups?
> Please help me with this task.
> Thanks,

Create Database with Filegroups restore Database without Filegroup

I have a SQL Server 2000 virtual server with Austin_Sales as the virtual
server name and REPT as the name instance. This is Active\Active Cluster with
Windows 2000 Advanced Server as the OS.
I have a new server and would like to have filegroups for the database. Can
I create filegroups on the new server and restore the backup from
Austin_Sales\REPT in the database with filegroups?
Please help me with this task.
Thanks,Restore will give you (essentially) a binary image of what is inside the database. I.e., you cannot
change filegroup layout through backup/restore. You'd have to do that before the backup or after the
restore...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:CFB09E6E-E210-4D53-B26E-98FFAC443E70@.microsoft.com...
> I have a SQL Server 2000 virtual server with Austin_Sales as the virtual
> server name and REPT as the name instance. This is Active\Active Cluster with
> Windows 2000 Advanced Server as the OS.
> I have a new server and would like to have filegroups for the database. Can
> I create filegroups on the new server and restore the backup from
> Austin_Sales\REPT in the database with filegroups?
> Please help me with this task.
> Thanks,

Create Database with Filegroups restore Database without Filegroup

I have a SQL Server 2000 virtual server with Austin_Sales as the virtual
server name and REPT as the name instance. This is Active\Active Cluster wit
h
Windows 2000 Advanced Server as the OS.
I have a new server and would like to have filegroups for the database. Can
I create filegroups on the new server and restore the backup from
Austin_Sales\REPT in the database with filegroups?
Please help me with this task.
Thanks,Restore will give you (essentially) a binary image of what is inside the dat
abase. I.e., you cannot
change filegroup layout through backup/restore. You'd have to do that before
the backup or after the
restore...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:CFB09E6E-E210-4D53-B26E-98FFAC443E70@.microsoft.com...
> I have a SQL Server 2000 virtual server with Austin_Sales as the virtual
> server name and REPT as the name instance. This is Active\Active Cluster w
ith
> Windows 2000 Advanced Server as the OS.
> I have a new server and would like to have filegroups for the database. C
an
> I create filegroups on the new server and restore the backup from
> Austin_Sales\REPT in the database with filegroups?
> Please help me with this task.
> Thanks,

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, 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@.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

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 ?
Thanks
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@.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

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