InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 15:07:19 GMT20http://www.sqlservercentral.com/Forums/Topic962019-338-1.aspxGoing through you request, i found that Table Partitioning might do the trick for you.. Me, in my sytem, implemented this Partition for Archive data; which is maintaining only the latest set (we have specific mechanism on we define sets using "versions" each time a job inserts data into the Archive tables) of data for each month in one filegroup and then "moving" the rest to the some another filegroup which will be located on a different drive..If you are interested in this process, try going this awesome whitepaper from Kim Tripp : [url=http://msdn.microsoft.com/en-us/library/ms345146%28SQL.90%29.aspx]Partitioned Tables and Indexes in SQL Server 2005[/url]Hope this helps! :-)Mon, 02 Aug 2010 07:04:50 GMTColdCoffeehttp://www.sqlservercentral.com/Forums/Topic962019-338-1.aspxAppending = InsertingPlease go through the [url=http://msdn.microsoft.com/en-us/library/aa933206%28SQL.80%29.aspx][b]INSERT statement details on MSDN[/b][/url].Mon, 02 Aug 2010 06:40:52 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic962019-338-1.aspxcan you suggest me query to append data in existing table dataMon, 02 Aug 2010 06:00:03 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic962019-338-1.aspx[quote]1)actually i want to transfer some data of these table to a different database. 2)after that i want to delete data from these tables, but each table shud have at least one month data.[/quote]1) The T-SQL query which will insert the requisite data into the other database2) A delete statement which will delete the copied data from the sourceMon, 02 Aug 2010 04:56:01 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic962019-338-1.aspxcan you suggest me what kind of sql script i'll have to write hereMon, 02 Aug 2010 04:21:13 GMTZeal-DBAhttp://www.sqlservercentral.com/Forums/Topic962019-338-1.aspxYou can accomplish through the [url=http://msdn.microsoft.com/en-us/library/ms141003.aspx]Execute SQL Task[/url]. You can write the custom sql script to meet your requirements.Mon, 02 Aug 2010 04:08:55 GMTAdigahttp://www.sqlservercentral.com/Forums/Topic962019-338-1.aspxhello experts, i have a database which has around 10 tables which stores log of different operations of application. as i said there are log tables so they grows frequently, some of these data i use in application also,actually i want to transfer some data of these table to a different database. after that i want to delete data from these tables, but each table shud have at least one month data. i how can accomplish that in a ssis package which i wud run every fortnightly and it will archive the data automatically, can any body suggest methank in advaceMon, 02 Aug 2010 01:55:35 GMTZeal-DBA