Results 1 to 7 of 7
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Backup backend safely (2000, 2003)

    Hi all,

    What methods can be used to backup a backend database which is in use?
    Can I just copy the data.mdb file safely?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Backup backend safely (2000, 2003)

    I've found that you can usually copy a database that is in use without problems in Windows Explorer, but you have to be careful: if data are being written to the database while you copy it, the copy may be corrupt.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backup backend safely (2000, 2003)

    Hmm. In this case ending up with a "valid" copy is important;

    We want to have a fall-back database on a different server to go to when the production server dies on us.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backup backend safely (2000, 2003)

    What about a scheduled task to backup the database at intervals? You could also program the database to copy the backend, say, as soon as it's opened?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backup backend safely (2000, 2003)

    Sure, but I want to know what a secure method is to do the actual copying. I've read that copying a database file which is being used may cause the copy to be corrupt. That is something I need to avoid.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backup backend safely (2000, 2003)

    Hmm...well, without kicking all the users off and then manually doing the backup, the next thing I could think of would be (with the scheduled task) using a BATch file to see if a database lockfile exists, and if one doesn't exist in the backend's directory, then executing the copy command.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backup backend safely (2000, 2003)

    Thanks. Typically my users would be "in" all day long.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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