dcsimg
Results 1 to 4 of 4

Thread: Database Archiving

  1. #1
    Join Date
    Jul 2009
    Posts
    2

    Database Archiving

    Hi,

    Are there any opensource database archiving solutions out there?

    Aware of expensive commerical solutons but wondering what options do DBAs use in general to reduce the size of individual large tables?

    Thanks,
    Tom

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Partition table if you are on sql2k5 and up.

  3. #3
    Join Date
    Jul 2009
    Posts
    2
    Hi,

    Thanks for that but I am really trying to do it via database archiving but it seems this is not a popular choice of action. Is there a reason for this as I thought it would be the simplest solution?

    Thanks,
    Tom

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    You can archive data simply with switching partitions.

Tags for this Thread

Posting Permissions

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