Re: data Archiving
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 08/03/04
- Next message: Amit: "Appending text to existing value in table column"
- Previous message: Narayana Vyas Kondreddi: "Re: timeout expired connecting to database"
- In reply to: sa: "data Archiving"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 3 Aug 2004 08:07:55 +0100
In general, this would be a nightly (off peak) job, and will be deleting
rows in appropriate chunks. For more info:
http://vyaskn.tripod.com/sql_archive_data.htm
-- Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ "sa" <sa@discussions.microsoft.com> wrote in message news:AD17C119-DBC8-4F3A-BC51-380A79AAF00E@microsoft.com... > Hello all, > we have a 20 gig table with 20 million records and we want to archive almost half (old data) of the data. Any help is highly appreciated. > > Thanks, >
- Next message: Amit: "Appending text to existing value in table column"
- Previous message: Narayana Vyas Kondreddi: "Re: timeout expired connecting to database"
- In reply to: sa: "data Archiving"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
