SQL Server Performance Forum – Threads Archive
Need help in Archiving Large Table’sI need some help in going about archiving some very large table’s
What are the quickest and most efficent way to go about this. I’m in a very bad spot here I know enough about SQL basic’s but our DBA has walked out and I’m left to pick up the pieces and from what I hear my company does not want to hire anyone….. Thanks 
You can do it using DTS. Take a look of BOL.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Hi,<br />read the following link :<br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9506′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9506′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9506>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9506</a></a><br /><br /><br /><br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’‘ />]<br />Regards.<br /><br />hsGoswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami<br />
A good linkhttp://vyaskn.tripod.com/sql_archive_data.htm from Narayan Vyas. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Can you be a bit more specific in your question? Without additional information any suggestion is likely to be a shot in the dark.
Microsoft SQL Server MVP
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)
Thanks for all of the Links …It put me on the correct path…