Data archiving

Question

What is the best way to archive data in sql server ??? Need suggestion.

Iftikar Hussain · Answer

Hi Please refer the below link http://stackoverflow.com/questions/18670902/best-way-to-archive-records http://stackoverflow.com/questions/296017/what-is-the-best-way-to-store-historical-data-in-sql-server-2005-2008 Regards Iftikar

Abhishek Jain · Answer

You can try this: http://vyaskn.tripod.com/sql_archive_data.htm http://stackoverflow.com/questions/1584783/sql-server-data-archive-solution Regards AJ