Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Unanswered: Archive and Back Up?????????:confused:

    I am doing a project on ordering entry system. and I got stuck on the archiving table and back up the whole database, could anyone please help ?

    I want to delete order which is over 60 days and archive those order into another tables. and also would like to back up the whole database.

    I will be very much appreciate if anyone could help me?

    Vicky

  2. #2
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    For archiving you can use the combination of append/update query and delete query to transfer data of order older than 60 days to archive table... that should be easy.

    but for backup it depends what method you want to use, many options are available

    1. just copy the whole database to backup folder
    2. zip the database to backup folder
    3. use any third party backup application...
    ...
    ...

    - Saqib

  3. #3
    Join Date
    Nov 2004
    Posts
    2
    Quote Originally Posted by Saqib
    For archiving you can use the combination of append/update query and delete query to transfer data of order older than 60 days to archive table... that should be easy.

    but for backup it depends what method you want to use, many options are available

    1. just copy the whole database to backup folder
    2. zip the database to backup folder
    3. use any third party backup application...
    ...
    ...

    - Saqib






    Hi,
    Thank you for your reply!
    Can you please axplain more in details about the archive table.
    Becuase I have tried to use append query to do that, but it didnt work.
    I would be very very very apprepicate if you can help.
    Many thx

    Vicky

Posting Permissions

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