The ideal situation is a full hot backup every minute.

You need to look at two factors:
1. How much data can you lose if there is a failure?
2. How long do you have to recover should there be a failure?

You need to integrate your backup plan with your Disaster Recovery and Business Continuity plan. The needs of you business will dictate the answers to these questions.

Oh, and export/import is NOT a valid backup plan for a production database.

[Edited by marist89 on 09-25-2001 at 11:21 PM]