No log operation

Hi
I have a database with full recovery model.
Every night at 11.00pm performs full backup, and dayly every 3 hours
performs differential backup, and trasnactional log backup performs
every 15 minutes during a day.

I am interested what operations i can not recover from log or
differential backup.

I saw that when i drop table i can recover it from log backup, but is
there some operation that can not be recover

Thanks a lot
Alex

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!"acko bogicevic" <aconi2002@.yahoo.com> wrote in message
news:406d2652$0$198$75868355@.news.frii.net...
> Hi
> I have a database with full recovery model.
> Every night at 11.00pm performs full backup, and dayly every 3 hours
> performs differential backup, and trasnactional log backup performs
> every 15 minutes during a day.
> I am interested what operations i can not recover from log or
> differential backup.
> I saw that when i drop table i can recover it from log backup, but is
> there some operation that can not be recover
> Thanks a lot
> Alex
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

In full recovery, all operations are logged, including truncating tables,
dropping objects, bulk loads etc., so you can always recover to any point in
time. See "Recovery models" in Books Online.

Simon