ADSM-L

Re: Full Vs Differential backups of SQL databases using TDP for SQL

2004-09-15 11:47:31
Subject: Re: Full Vs Differential backups of SQL databases using TDP for SQL
From: Del Hoobler <hoobler AT US.IBM DOT COM>
Date: Wed, 15 Sep 2004 11:46:51 -0400
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

<Prev in Thread] Current Thread [Next in Thread>