database backup

• sunilkumar

  Valued Member

  Points: 52

  More actions

  March 22, 2004 at 11:31 pm

  #152085

  Hi,

  i had a problem . I had to take backup's from my clients database everyday and update the database in my office. the problem is my client is staying in a remote place and we didnt have any connection for their servers all we have to do is to make a back up copy them in a disk and then run them in our systems.

  how can i do this ?

  can anyone help me to sort out this ?

  Thanks in advance.

   

• Peldin Fernandes

  SSC Enthusiast

  Points: 186

  More actions

  March 23, 2004 at 1:05 am

  #499961

  hi Sunil Kumar

  I would request you to write a small database utility which will pick up data from the tables which are inserted or updated, or deleted u may do this by keeping logs in a log table. the data picked can then be placed in a mirror copy of your database and copy to cd this process can be automated, on the other side u can write another utility to restore this data back to your main database.

  We had used a similar approach for Election Data. which needed to be shipped to individual booths. and brought back to the central location after capturing.

  Thank you I hope it helps you out..

  Regards,
  Peldin Fernandes