Post reply

Archiving the data

  • June 12, 2009 at 1:25 am

    #205947

    Hi,

    Wht is the best way to archive the database on daily basis

    -Narendra

  • June 12, 2009 at 2:11 am

    #1008431

    As with any Microsoft question "It depends".

    (1) If you are just wanting to move the data out of the table then create archive table(s) to move the data in. Then run a job on a daily/weekly basis to copy to the new tables and and then remove the existing records.

    (2) As above you can create a new db on the same or different server.

    There are others but these are the easiers

    The link below gives a good demo.

    http://vyaskn.tripod.com/sql_archive_data.htm

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

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