InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 14:12:25 GMT20http://www.sqlservercentral.com/Forums/Topic1427791-1550-1.aspx[quote][b]vineet_dubey1975 (3/7/2013)[/b][hr]My both the DBS are on same file filegroup e.g. PRIMARY.[/quote] Refer the link i posted aboveThu, 07 Mar 2013 04:06:33 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1427791-1550-1.aspxMy both the DBS are on same file filegroup e.g. PRIMARY.Thu, 07 Mar 2013 02:07:37 GMTvineet_dubey1975http://www.sqlservercentral.com/Forums/Topic1427791-1550-1.aspx[quote][b]vineet_dubey1975 (3/6/2013)[/b][hrCan i move 'TBLHistory' to HistoryDB and still i can perform switch out and Switch in?Note:Both DBs are residing on same instance of the server.[/quote] NO . for switch-in & switch out , tables should be resided on partitoned filegroups. see this link [url]http://sqlserverpedia.com/wiki/Switching_Partitions_-_Example[/url]Thu, 07 Mar 2013 01:00:19 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1427791-1550-1.aspxHi All,I have a daily partitioned table 'TBL' and I hold data for 30 Day's. I archive data to TBLHistory table by Switch out minimum partion and switch in the partition to TBLHistory.The Main Table 'TBL' and 'TBLHistory' resides on the same database. As a result size of database is increasing.My manager ask me to Create a HistoryDB database and move 'TBLHistory' to the history database.Can i move 'TBLHistory' to HistoryDB and still i can perform switch out and Switch in?Note:Both DBs are residing on same instance of the server.(MainDB) -->TBL-->SwithOut to --> Swith In to --> (HistoryDB)-->TBLHistory ?Please guide me how can i best achive this.Thanks Vineet DubeyWed, 06 Mar 2013 23:49:15 GMTvineet_dubey1975