We are trying to free up some space in our old database, there is one table(Table_Test) which is using most of the space. How can we keep the structure of the table and all its indexes intact and just delete some data (retaining only latest 2 months data). We still use this database and its tables for weekly loads and append it to the new database.
The indexes of Table_Test is bigger than the table itself..
Please let me know your comments and suggestions