Backing up an sql server
Created: 27 May 2013 • Updated: 27 May 2013 | 3 comments
I am running BE 2012 and trying to backup an SQL server 2008.
I have several questions after playing with the agent for a few hours :
- My full backup is 40GB big. A couple of minutes after taking a full backup, I run a log backup. Size is 10GB. Then right after that I run a differential backup. Size is 20MB. Why is the log backup so big ? It is clearly impossible that 25% of my database content changed in a few minutes.
- What's point of taking differential AND log backup ? I clearly see the advantage of the log backups that allows to go back in time whenever we want beteween the full and the log backup. So why also take differentials ?
- Also if it is a good practice to have log backups and differentials, when do you shedule the them ? at the same time ? right after each other ? Please share with me the schedules you have set for the 3 backups (full, log, differential).
- On my sql server, I have DBs that have a recovery mode set to Full, while others have a simple recovery mode. So I added log backup to my original backup exec job. Now instead of having a warning saying that "XXXX is configured to maintain transaction logs. Transaction log backups are not being performed.", I get a warning saying that "A log backup was attempted on database YYYY that is not configured to support log backups. To change the configuration, use the SQL administration tools to set the recovery mode to Full.". Is there way to keep DBs in full and in simple recovery mode, and avoid having exceptions ? I also would like to avoid having 2 different backup exec jobs in which I would have to add manually the DBs.
- Finally, could I see what retention you have set to make sure I dont do a setup where log/differential would be deleted before the full backup ?
Thanks for the help