Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database backup

Status
Not open for further replies.

joeblow3

Programmer
Jun 9, 2008
21
CA
Hi:

I need help in finding out how to make a backup of my database. When I look at the size of the file of my backend (database) it is about 10 MB. However, when I go to Tools|Database Utilities|Backup Database, it only creates a file of about 1 MB.

This is causing me to wonder if using the menu as described above is really creating a backup. In the event that my current database gets corrupted or becomes unusable will I be able to refer my frontend to point to the backedup database of 1 MB that I would have created?

Just making a file copy/paste of my database file (10 MB) gives me an error saying something to the effect that copying the database file will result in some information being lost.

Any help will be much appreciated.

Thank you.
 
What is the size of your backend after a Compact'n'Repair ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Thanks PH.

I realize that it makes a compact and repair when doing a backup.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top