A database like the SkyWrite database becomes a valuable asset to a company and needs to be carefully maintained. You must make backup copies on a regular basis.
In this lesson you have:
•Learned the difference between copying database files and backing up database files.
•Learned the importance of back ups.
•Backed up the SkyWrite database to a floppy disk using the UNLOAD command.
•Learned the difference between packing or compressing a database in place, and packing to another file.
To check your knowledge, try answering the following questions:
1. | Why is it important to make regular backup copies of your database? |
2. | What are the database files? |
3. | What is the command used to restore a database? |
4. | What is the purpose of the Reload and Pack In Place options, and how do they differ? |
5. | What should you always do before packing (compressing) your database? |