best recovery mode

hi friends,
what should be the best recovery mode to implement.it is simple,full,bulklog
back.
which should be the efficient .
what is the microsoft recommendations for this
please help
thanks
reddyHi,
We can not differentiate and tell which one is good and which one is bad,
Recover model selection purely depends
on the data inside the database and type of recovery business requires.
FULL :- For production data which requires point-in-time recovery
BULK_LOGGED :- For production with high bulk operations and which do not
need a point-in-time recovery
SIMPLE :- For test and development environments. The recovery can be done
only till the last full backup.
Have a look into "Selecting a Recovery Model" in Books online for more
details.
Thanks
Hari
MCDBA
"reddy" <reddy@.discussions.microsoft.com> wrote in message
news:E42CF3FF-F4EC-476C-AFC0-D81428240791@.microsoft.com...
> hi friends,
> what should be the best recovery mode to implement.it is
simple,full,bulklogback.
> which should be the efficient .
> what is the microsoft recommendations for this
> please help
> thanks
> reddysql