InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 20:43:01 GMT20http://www.sqlservercentral.com/Forums/Topic1407735-392-1.aspx[quote][b]Bhuvnesh (1/16/2013)[/b][hr][quote][b]Suresh B. (1/16/2013)[/b][hr]However, the filegroup can be different from that of the corresponding tables or other corresponding indexes.[/quote] What does it mean ?[/quote]It means table and index can be reside on different filegroup. But they must move to thier corresponding filegroup.For example: Let's say Table1 is on filegroup Data1. And an index called IX_Table1_Name is on filegroup Index1.They should move to thier corresponding filegroup on the same database.Wed, 16 Jan 2013 05:27:58 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic1407735-392-1.aspx[quote][b]Suresh B. (1/16/2013)[/b][hr]However, the filegroup can be different from that of the corresponding tables or other corresponding indexes.[/quote] What does it mean ?Wed, 16 Jan 2013 05:19:59 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1407735-392-1.aspxNo. It's not possible.Not only in the same database, objects should be in the same filegroup.BOL:[quote]Source and target tables must share the same filegroup. The source and the target table of the ALTER TABLE...SWITCH statement must reside in the same filegroup, and their large-value columns must be stored in the same filegroup. Any corresponding indexes, index partitions, or indexed view partitions must also reside in the same filegroup. However, the filegroup can be different from that of the corresponding tables or other corresponding indexes.[/quote]Wed, 16 Jan 2013 05:13:22 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic1407735-392-1.aspxis it possible to switch the data from one database to another. See the below test code [code="sql"]USE [AdventureWorks2008R2]GOALTER TABLE orders_part SWITCH PARTITION 1 TO TailspinToys.dbo.orders_part_2[/code]Error [i]Msg 4948, Level 16, State 1, Line 1ALTER TABLE SWITCH statement failed. The source table 'orders_part' is in database 'AdventureWorks2008R2' while the target table 'TailspinToys.dbo.orders_part_2' is in database 'TailspinToys'.[/i]Wed, 16 Jan 2013 04:20:23 GMTBhuvnesh