[Networker] Stupid MS SQL backup question
2010-10-21 17:38:43
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [Networker] Stupid MS SQL backup question,
Ole Hermansen <=
- [Networker] Total Save Group size, Morton, Jeffrey
- Re: [Networker] Total Save Group size, Len Philpot
- Re: [Networker] Total Save Group size, Morton, Jeffrey
- Re: [Networker] Total Save Group size, DSouza, RovinAbishek
- Re: [Networker] Total Save Group size, Morton, Jeffrey
- Re: [Networker] Total Save Group size, James Pratt
- [Networker] Way to associate nsrnmmd PID to particular drive?, Morton, Jeffrey
- Re: [Networker] Way to associate nsrnmmd PID to particular drive?, Len Philpot
- Re: [Networker] Way to associate nsrnmmd PID to particular drive?, Francis Swasey
- Re: [Networker] Way to associate nsrnmmd PID to particular drive?, Thierry FAIDHERBE
|
|
|