Tuesday, April 12, 2005

What does it mean well maintained database?

A well-maintained databases, means those that have

1. A well-planned backup and restore strategy

2. An effective log monitoring,

3. Databases for which capacity planning and testing have defined an appropriately
sized transaction log


4. Operations that clear the transaction log—other than normal log backups --
— should never occur.

No comments: