Hi all.
 
I have a stupid question regarding online SQL backup.
 
If we assume that a database is in "Full Recovery Mode ", does it then makes
sense to do a differentaL backup?
I believe that level full and incremental should be sufficient.
 
In our company we make daily backups on many SQL servers, and our schedule
is set to differental every evening except Friday where we are performing
full backups.
 
In addition to full and differental backup, we run incremental backup
several times a day, and until now I've only been in need of full and
incremental backups for restore.
 
The only time I can imagine that a differental backup is needed is if the
databases were set to "Simple Recovery Mode".
 
Am I completely wrong ?
 
The reason for my question is that we daily run several Terrabytes of
differental SQL backup and would like to spend the time and resources on
something else.
 
Best Regards
Ole Hermansen
No virus found in this outgoing message.
Checked by AVG - www.avg.com 
Version: 9.0.862 / Virus Database: 271.1.1/3210 - Release Date: 10/21/10
08:34:00


To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER