Moses,

Many of the answers here come from a general
understanding of SQL Server backup/restore strategy.
Here is some very good reading material for you:


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_4l83.asp

As far as a Data Protection for SQL impact, you mentioned
the main ones, i.e. storage and network bandwidth savings
by using a full + differential strategy.
Also, depending how the data is stored, i.e. on tapes or disk
and how many stripes you use for backup, would have a
determination of how many tape mounts you might require
for a restore operation.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 09/15/2004
10:48:19 AM:

> Hi people,
>         We are currently using TDP for SQL to take full backups of
> databases which reside on SQL servers. This is done on a daily basis.
> Other than storage issues are there any other real benefits which could
be
> gained by backing up servers with a combination of Full and differential
> backups.
> Also are there any important issues which would need to be addressed
> before this could happen, assuming it is feasible.
>
> How would using a combination of the two methods impact an any databse
> restores should we need to do them ?
>
==============================================================================