03-25-2013 07:07 PM
I just created a new backup job on a sql server in BE2012. I ran a full backup yesterday and it completed successfuly with no exceptions. My first incremental job ran tonight and I had 3 exceptions. They were as follows:
Solved! Go to Solution.
03-29-2013 07:07 PM
You have already backed up your SQL databases so you can restore the databases from these backup. Since the databases with the exceptions are on simple recovery mode, there is no logs to recover so the error messages do not matter.
There is no way to have one incremential job without exceptions?
Yes. You need 2 jobs because you have databases with different recovery modes.
If you do not require point-in-time restores, then you can set all the databases to simple recovery mode and you want to do away with log backups, Before you set your databases to simple recovery mode, you should check with the database owners whether simple recovery mode is acceptable. Some applications must have full recovery mode.
For fuller explanations of SQL recovery modes and point-in-time restores, do search the Web.
03-25-2013 07:30 PM
The recovery mode for the databases indicated in the error messages are set to simple, i.e. they do not maintain transaction logs. You should exclude them from your transaction log backups. You would need to set up two set of jobs to backup your SQL databases. One set of jobs will include log backups and would backup those databases which have full recovery mode and the other set of jobs will NOT have log backups and would include those databases which have simple recovery mode.
03-29-2013 10:45 AM
Pkh, I kinda understand your post, but at the same time I do not.... If system failure happened and I tried to restore the system am I correct that everything would restore but those that were exceptions. There is no way to have one incremential job without exceptions?
03-29-2013 07:07 PM
You have already backed up your SQL databases so you can restore the databases from these backup. Since the databases with the exceptions are on simple recovery mode, there is no logs to recover so the error messages do not matter.
There is no way to have one incremential job without exceptions?
Yes. You need 2 jobs because you have databases with different recovery modes.
If you do not require point-in-time restores, then you can set all the databases to simple recovery mode and you want to do away with log backups, Before you set your databases to simple recovery mode, you should check with the database owners whether simple recovery mode is acceptable. Some applications must have full recovery mode.
For fuller explanations of SQL recovery modes and point-in-time restores, do search the Web.