DPM cannot backup SQL database with transactions log while recovery model of database is SIMPLE. You have to just change “Recovery model” of your DB in SQL Server Management Studio.
1) Log on SQL Server Management Studio
2) Right click on database – Properties
3) In the left pane choose Options
4) Set the recovery model to Full
Create a new SQL Query (use “New query” button on the standart bar):
USE YourDBNameHere ;
ALTER DATABASE YourDBNameHere SET RECOVERY FULL ;
5) Open your DPM Console and run Consistency Check on all databases with the same error.
In previous post I described how to upgrade DPM 2012 to SP1. If you installed Data Protection Manager (DPM) 2012 Service Pack 1 you must update the protection agents on the computers you are protecting. You can update the protection agents using DPM management console (if you have domain), or you can update them manually using the command line interface (if you have workgroup). Updating agents in workgroup doesn’t work through DPM management console. You can try, but DPM will show you the following error:
Yeap, you already know why DPM shows this error (how to update agents in workgroup using packages from Protection Agents folder on DPM Server). But the most important fact in this article that we have to deploy update KB2802095 for existing protection agent (version 4.1.3133.0) using following path:
<DriveLetterWhereDPMisinstalled>\Program Files\Microsoft DPM\DPM\Agents\RA\<latest agent version>\AMD64\1033\DPMAgentInstaller_KB2802095_AMD64.exe
Open this path on your target server and run EXE. Check agent version:run your DPM console > Management > highlight your agents in workgroup and click Refresh.