We deal with a very large database that grows at an avrage of 50GB a month. The current database size is 700 GB. All the transaction tables are horizontally partitioned to seperate filegroups assigned to a individual data files holding each months data. What would be the best strategy to retain another archive server that holds data prior to 1year and retain the production server with the recent 1 year data?
July 2, 2008 10:24 AM
November 1, 2011 9:57 AM