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

No Differential Backup on Master DB

Hi, Can someone plzz explain the below reason
"Differential backups are not allowed for the master database since
they require that complete backups be applied without recovery as the
first step. When restoring the master database, restore without
recovery is not allowed."
Hi
If you look in BOL on how Master DB needs to be restored, you will notice
that it is not an easy procedure.
If Master DB gets bigger than a manageable size (say 100Mb), then you have a
serious problem. You have user objects in there and you are compromising
your recoverability of your server.
A small DB like Master needs no differential backups and not much changes in
it, and it is so quick to do a full backup, that it is not worth the effort.
Regards-
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1131737977.922320.82800@.g14g2000cwa.googlegro ups.com...
> Hi, Can someone plzz explain the below reason
> "Differential backups are not allowed for the master database since
> they require that complete backups be applied without recovery as the
> first step. When restoring the master database, restore without
> recovery is not allowed."
>

No Differential Backup on Master DB

Hi, Can someone plzz explain the below reason
"Differential backups are not allowed for the master database since
they require that complete backups be applied without recovery as the
first step. When restoring the master database, restore without
recovery is not allowed."Hi
If you look in BOL on how Master DB needs to be restored, you will notice
that it is not an easy procedure.
If Master DB gets bigger than a manageable size (say 100Mb), then you have a
serious problem. You have user objects in there and you are compromising
your recoverability of your server.
A small DB like Master needs no differential backups and not much changes in
it, and it is so quick to do a full backup, that it is not worth the effort.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1131737977.922320.82800@.g14g2000cwa.googlegroups.com...
> Hi, Can someone plzz explain the below reason
> "Differential backups are not allowed for the master database since
> they require that complete backups be applied without recovery as the
> first step. When restoring the master database, restore without
> recovery is not allowed."
>sql

No Differential Backup on Master DB

Hi, Can someone plzz explain the below reason
"Differential backups are not allowed for the master database since
they require that complete backups be applied without recovery as the
first step. When restoring the master database, restore without
recovery is not allowed."Hi
If you look in BOL on how Master DB needs to be restored, you will notice
that it is not an easy procedure.
If Master DB gets bigger than a manageable size (say 100Mb), then you have a
serious problem. You have user objects in there and you are compromising
your recoverability of your server.
A small DB like Master needs no differential backups and not much changes in
it, and it is so quick to do a full backup, that it is not worth the effort.
Regards-
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"sasiraj" <vardhansasi@.gmail.com> wrote in message
news:1131737977.922320.82800@.g14g2000cwa.googlegroups.com...
> Hi, Can someone plzz explain the below reason
> "Differential backups are not allowed for the master database since
> they require that complete backups be applied without recovery as the
> first step. When restoring the master database, restore without
> recovery is not allowed."
>