O'Reilly logo

Databases for Small Business: Essentials of Database Management, Data Analysis,and Staff Training for Entrepreneurs and Professionals by Anna Manning

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER  11

Maintaining Your Database

Database maintenance aims to keep a database running smoothly. Databases are not static; data is added, deleted, and moved around and, over time, such changes can cause the database to become sluggish. A poorly performing database can cost you money and waste users’ time. Database maintenance includes backing up your database, compacting the database, and protecting the data. There are overlaps between this chapter and data cleansing, which is discussed in Chapter 10. This chapter discusses the jobs that you need to carry out on a regular basis.

Backing Up Your Database

One important aspect of maintaining a database is simply backing it up regularly. That way, if anything happens to it, there will be another ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required