Database Archiving(SQL Server 2005)

  • Dear All,

    I Have a data base in sql server 2005 having huge amount of data of 10 finanacial year.

    I want to archeive 2 yras data in a separate database.

    If anybody help, then highly apreciated.

    please scpecify the steps.

    Thanx in advance

    Regards,

    San

  • Easiest way is to backup and restore as a new database (new name), delete the data in each database you don't need.

    If you do this regularly, you need to build a series of scripts that will insert data in the archive database from the main database using some criteria. I assume you can tell which transactions are old and which are not. Then delete the old data from the main database.

  • As Steve mentioned if you would like to do this in regular basis you can use partitioning

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply