Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Archieving the Data policy

Author  Topic 

ms.gangadhar
Starting Member

8 Posts

Posted - 2012-06-04 : 04:24:21
Dear All,

We have 3 main transactional tables and they are getting filled very frequently and i need to move those table records(3 month older records) to archive/History table for every month on scheduled basis to improve the performance.

Could you pls suggest which is best way to do this.Any reference link will behelpful

Server : SQL 2005 Enterprise Edition.

Thanks,
Gangadhara
   

- Advertisement -