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 ...