Post reply

Data Archiving

  • October 25, 2006 at 6:36 am

    #62456

    How to archive data from my production database? Is there a tool or command built-into SQL Server for this?

    How can I access the pevious data, If I archive the data from the production to another database.

    Thank You

    Thanks ,

    Shekhar

  • October 25, 2006 at 8:53 am

    #667889

    There's no built-in way to do this in SQL Server.  You'll have to build it yourself using DTS, replication, log-shipping, or T-SQL depending on your requirements (location of the archive database, how accessible does it need to be, etc.).

    Greg

    Greg

  • October 25, 2006 at 9:58 am

    #667910

    If performance is your problem as opposed to space, I would look at partitioning the table.  Books online has a good deal of information about this, and from what I have done performance is pretty good.

    Tom

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

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