We have database 'testDb' with 5 tables. mainly 'user_details_tab' and 'user_deatils_backup_tab'. The database 'testdb' filled with large volume of data daily. The data in 'user_details_tab' moves to 'user_deatils_backup_tab' and clears 'user_details_tab' in each day. The problem is that, 1.after 2 or weeks the backup 'user_deatils_backup_tab' table contain millions of data. this will effect the querying of data in that table. 2.millions of data inserted into this database daily . In this situation i cann't imagine appliction running continously for year or more . note: Need to backup this database Any one can suggest a solution to this problems ?