Archive Data in MSSQL2000 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Archive Data in MSSQL2000

Hello Is there a way to Archive data in a table in MSSQL 2000 so that those data
wont be a part of the system when sql do a searching etc.
Does Sql2000 support archiving?

You have to implement your own logic for this. —
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?
Ich unterstuetze PASS Deutschland e.V.
True and will help you with basic idea. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks Frank and Satya. I guess after reading that article, i have to create a Temp or Archive table same as the original one which i am going to use
and then pass a date value and filter all those records and put into the archive tables and then delete the records from the parent tables. So that means SQL2000 dont support archive options is that correct?