Backup opinions

[Adam]

I have a database that I am going to split. I will put
the backend on the server and copies of the frontend on
the workstations. I would like to have some source
of "auto" backing up the database. Would backing up the
backend only be my concern?

Is there any way to have some sort of auto back up these
databases once a week? what about the fear of backing up a
corrupt database?

thanks,

Adam

 

[Arvin Meyer]

Full Backup of the server should happen once per week with an incremental
backup happening daily. That means that the backend will be backed up daily.
The automatic backup is done with backup software/hardware that runs on the
server. It has its own built-in scheduler.

I keep a copy of the front-end on the server so that's also backed up at
least once a week if there are no changes. That makes it easier to
distribute changed features. i.e. put the changed front-end on the server,
link it, if necessary, to the back-end, then have everyone download a copy.
I have a free utility that checks newer versions on the server and
automatically downloads them if they exist.

http://www.datastrat.com/Download/Starter.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access