I have a serious problem here. I have a Audit database of 620 GB with just two tables in it. This database has 2 years worth of data. Both these tables have around 900 million rows in each of them. Each of the tables get around total of 2-3 million
rows everyday. This database is on SQL Server 2005 Enterprise Edition. Machine has just 870 GB of total Space Drive. We are left with just 180 GB of free space. Now I have a requirement to make it smaller and keep just 1 year of data in live database. I have
a option of purging the data every week. But I believe it wont be easy to purge such a large of rows if we do purging just on weekends.
Can you please suggest me some ways to attain this goal of 1 year of data in database ? Also if you could you suggest for future how can i maintain the database. I am not able to do any maintenance task(like re-indexing,update stats etc..) on
Please help me to find some solution for it.
View Complete Post