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 datawont 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
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
True andhttp://vyaskn.tripod.com/sql_archive_data.htm will help you with basic idea. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
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?
]]>