Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010

    Unanswered: How to archive old data

    Hi guys,

    I want to archive old data for optimisation. How to do it??

    Thanks a lot

  2. #2
    Join Date
    Mar 2007
    Holmestrand, Norway
    Actually, it is no way for us to tell you how you should do it, as it depends on a lot of factors, like version of SQL Server and how your application is working and of course how large amount of data you've got. Among your options you have:
    * Rewrite Stored Procs/Ad Hoc queries to move data (delete from ... output) when certain conditions are met.
    * Use SSIS/Stored Procs to move data on a regular basis
    * Implement partitioning
    Ole Kristian Velstadbråten Bangås - Virinco - - Facebook - Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts