Difference between Full recovery, Bulk-logged, Simple recovery

what is the difference between Full recovery, Bulk-logged, Simple recoveryhi joe
full recovery means the entire db is recovered
bulk logged means part of the log is recovered
certain bulk operations are not recovered
refer teach urself in 21 days by sams
"Joe" wrote:

> what is the difference between Full recovery, Bulk-logged, Simple recovery|||Under bulk-logged recovery model, once you do a log backup, all extents that
were allocated as part bulk-logged operations are backed up. So potentially
your transaction log can be huge. The only caveat is that you cannot do
point-in-time recovery from a log backup that contains bulk-logged
operations. But you can always recover at the transaction log boundary (i.e.
you can apply the full log that contains bulk-logged operations).
thanks
--
Sunil Agarwal (MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"raghu veer" <raghuveer@.discussions.microsoft.com> wrote in message
news:D304EEF7-FB2A-478E-B2FF-0A5343D5446B@.microsoft.com...[vbcol=seagreen]
> hi joe
> full recovery means the entire db is recovered
> bulk logged means part of the log is recovered
> certain bulk operations are not recovered
> refer teach urself in 21 days by sams
> "Joe" wrote:
>|||"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:81E7D411-8776-40B4-B3C4-A4B1B020CEDD@.microsoft.com...
> what is the difference between Full recovery, Bulk-logged, Simple recovery
Are you serious'
Why do you need to know?
Did you get a job as a SQL Server DBA without knowing this? Scary. Go to you
boss' office and hand in your resignation.
Is it a homework question for school? Are you so lazy and incompetent that
you cannot be arsed to research this by yourself?
You are a disgrace.
Foz