Hi Jeff,

You have suggested 3 different solutions for backup. But, in most of the places there will be some
constraints like
1. Cost involved in buying all the required softwares
2. Cost involved in buying the necessary storage devices etc.

That is true in my case also.
This is what I follow:

1. Every week I take a cold backup and move it to the backup server.
2. We have veritas backup agent which will take online backup of the databases in a daily
basis and move them to the (same) backup server.
3. Users will take a user level export on a daily basis.

In this kind of a situation what other method can be followed.

Thanks.
Vijay.