I have a database that is about 38mb. So for I have about 2 years worth of data in it. I have now been told that i am to keep only 1 years worth of data and that each month I need to delete or remove and save the old data someplace esle. Then I have to run compress on the new database.
I understand about running the compression after I have removed the data. BUT, what does deleteing older (by 1 month) data do for me? Management thinks that by deleting data it will help the database run faster, smoother and cause less problems. My concern is that by deleteing data each month and running compresson so often this might cause problems.