Data Archival/Purging - through table partition switch IN/OUT

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Data Archival/Purging - through table...

Data Archival/Purging - through table partition switch IN/OUT

Rate Topic

Display Mode

Topic Options

Author

Message

vineet_dubey1975

Posted Wednesday, March 06, 2013 11:49 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:22 AM
Points: 322, Visits: 332

Hi 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 Dubey

Post #1427791

Bhuvnesh

Posted Thursday, March 07, 2013 1:00 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

vineet_dubey1975 (3/6/2013)[hr
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.

NO . for switch-in & switch out , tables should be resided on partitoned filegroups. see this link http://sqlserverpedia.com/wiki/Switching_Partitions_-_Example

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1427817