Access backup software

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sue W via AccessMonster.com
    #1

    Access backup software


    We have a database that is in use 24/7, and does not get backed up by our
    network backup software because it is always open. Does anyone have
    experience with backup software specifically designed for Access which claims
    to back up open Access databases? (One example is something called Access
    Database Autopilot.) The pessimist in me tends to distrust such things.

    We currently are asking the end user in charge of this db to kick everyone
    out of the db every evening, turn off an automated process which also hits
    the db, then manually make a copy of the db.
    Tags: None
    • lesperancer@natpro.com
      #2
      Re: Access backup software

      the safest is to move your backend to SQL server / MSDE which has the
      capability to do this type of backup to a disk file which you can then
      store offsite, or burn on CD or ...

        Comment

        • Baz
          #3
          Re: Access backup software

          "Sue W via AccessMonster.c om" <forum@AccessMo nster.com> wrote in message
          news:51FFB75D3C 46F@AccessMonst er.com...[color=blue]
          >
          > We have a database that is in use 24/7, and does not get backed up by our
          > network backup software because it is always open. Does anyone have
          > experience with backup software specifically designed for Access which[/color]
          claims[color=blue]
          > to back up open Access databases? (One example is something called Access
          > Database Autopilot.) The pessimist in me tends to distrust such things.
          >
          > We currently are asking the end user in charge of this db to kick everyone
          > out of the db every evening, turn off an automated process which also hits
          > the db, then manually make a copy of the db.[/color]

          You can schedule a job using the Windows scheduler which copies the database
          before the backup (just a simple file copy). The copy will not be open, and
          hence will be backed up.

          Some people will tell you there is a risk that if you copy an open database
          then the copy could be corrupt. Doubtless they are theoretically correct,
          but I have loads of experience with automatically backing up open databases
          in this way, and I have never encountered a corrupt copy. To be on the safe
          side, you could automatically make several copies, one after another. If
          the chances of one copy being corrupt are small, then the chances of several
          being corrupt are vanishing.


            Comment

            • Sue W via AccessMonster.com
              #4
              Re: Access backup software


              Baz wrote:[color=blue]
              >Some people will tell you there is a risk that if you copy an open database
              >then the copy could be corrupt. Doubtless they are theoretically correct,
              >but I have loads of experience with automatically backing up open databases
              >in this way, and I have never encountered a corrupt copy. To be on the safe
              >side, you could automatically make several copies, one after another. If
              >the chances of one copy being corrupt are small, then the chances of several
              >being corrupt are vanishing.[/color]

              Thanks, it sounds like it would be worth trying to copy the open database a
              few times and seeing how consistently we get good copies!


              lesperancer@nat pro.com wrote:[color=blue]
              >the safest is to move your backend to SQL server / MSDE which has the
              >capability to do this type of backup to a disk file which you can then
              >store offsite, or burn on CD or ...[/color]

              Unfortunately, this is a vended software program that uses an Access backend
              (still!), very much to our chagrin. Our database is 200mb and we aren't even
              using half of what the program does; I can just imagine the problems other
              companies with bigger db's are having using such large Access db's over a
              network.


              --
              Message posted via http://www.accessmonster.com

                Comment

                • Baz
                  #5
                  Re: Access backup software

                  "Sue W via AccessMonster.c om" <forum@AccessMo nster.com> wrote in message
                  news:5203476D06 CB9@AccessMonst er.com...[color=blue]
                  >
                  > Unfortunately, this is a vended software program that uses an Access[/color]
                  backend[color=blue]
                  > (still!), very much to our chagrin. Our database is 200mb and we aren't[/color]
                  even[color=blue]
                  > using half of what the program does; I can just imagine the problems other
                  > companies with bigger db's are having using such large Access db's over a
                  > network.
                  >
                  >
                  > --
                  > Message posted via http://www.accessmonster.com[/color]

                  200Mb is nothing, it's well within the capabilities of Access (assuming, of
                  course, that the design is good!). I would never advise upsizing to SQL
                  Server simply because a database had reached a mere 200Mb (although there
                  may be other compelling reasons).


                    Comment

                    • Wayne Morgan
                      #6
                      Re: Access backup software

                      Many backup programs offer an "open file option" that takes a snapshot of
                      the files before doing the backup. If you are running WinXP or Windows 2003
                      Server, then Shadow Copy may be able to do this for you. You may want to ask
                      the Windows folks in the appropriate newsgroup for your version of Windows.

                      --
                      Wayne Morgan
                      MS Access MVP


                      "Sue W via AccessMonster.c om" <forum@AccessMo nster.com> wrote in message
                      news:51FFB75D3C 46F@AccessMonst er.com...[color=blue]
                      >
                      > We have a database that is in use 24/7, and does not get backed up by our
                      > network backup software because it is always open. Does anyone have
                      > experience with backup software specifically designed for Access which
                      > claims
                      > to back up open Access databases? (One example is something called Access
                      > Database Autopilot.) The pessimist in me tends to distrust such things.
                      >
                      > We currently are asking the end user in charge of this db to kick everyone
                      > out of the db every evening, turn off an automated process which also hits
                      > the db, then manually make a copy of the db.[/color]


                        Comment

                        • Tom Crawford
                          #7
                          Re: Access backup software

                          I have a similar problem with my customer db. I also COPY the open db to a
                          Temp location/name, compact the temp file (this should show any corruption
                          that may occurr) and then copy the compacted temp file to a final
                          destination. So far (~6mo) no corruption issues or problems. I've gone so
                          far as to to the backup automatically in the background and the operators
                          don't even have to stop any processes. I only inform them if there is an
                          error.

                          I'm using the File Copy routine from the Access Web written by Dev Ashish.


                          "Sue W via AccessMonster.c om" <forum@AccessMo nster.com> wrote in message
                          news:51FFB75D3C 46F@AccessMonst er.com...[color=blue]
                          >
                          > We have a database that is in use 24/7, and does not get backed up by our
                          > network backup software because it is always open. Does anyone have
                          > experience with backup software specifically designed for Access which
                          > claims
                          > to back up open Access databases? (One example is something called Access
                          > Database Autopilot.) The pessimist in me tends to distrust such things.
                          >
                          > We currently are asking the end user in charge of this db to kick everyone
                          > out of the db every evening, turn off an automated process which also hits
                          > the db, then manually make a copy of the db.[/color]


                            Comment

                            Previous template Next
                            Working...