InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:45:26 GMT20http://www.sqlservercentral.com/Forums/Topic1357894-391-1.aspxWhat about setting up an 'archive' disk array and partitioning the table(s) with the data to be archived on the 'archive' disk array?Wed, 12 Sep 2012 07:51:27 GMTsestell1http://www.sqlservercentral.com/Forums/Topic1357894-391-1.aspxGood Day,we need to archive old data from a live database to the archive files in the same database as the users need to interrogate the archive data quite regularly . We asked the vendor about a dedicated archive database, but he mentioned that this would complicate the system as it is . Any ideas ?Wed, 12 Sep 2012 05:04:12 GMTlianvh