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" <[EMAIL PROTECTED]> 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 ? > ==============================================================================
