DPM 2010 didn’t notice the change of recovery mode.

As everybody knows, to have perfectly protected SQL database it has to be in Full recovery mode. This is the main requirement for x hour synchronization to addition to daily backup. But when we have configured Protection Group for SQL Instance and after we will change recovery mode for a single database .. what will happen? Nothing! DPM won’t notice anything. Solution is quite simple, we just have to exclude our database from Protection Group and then add it again. After this, DPM will also take care of this database during synchronization.

DPM 2010 and spaces in names of SQL mdf and ldf files.

For some reason, DPM cannot backup properly SQL Database when there is a space at the beginning or at the end of mdf/ldf file. For example database with mdf file “  BaseA.mdf” won’t be backed up and there won’t be any clear error message just something like “Replica creation failed”. So if you have any problem with SQL backup it’s good to start investigation with checking file names – in my case it was bull’s eye. I have found description of similar problem in DPM 2007, let’s hope that it will be fixed sooner or later.