Understanding DPM 2012 R2 For Backing Up SQL Server

How does DPM handle SQL server incremental backups?
I was expecting to be able to recover the logs back to any given 60 minute interval that i set in the synchronisation settings.
Am I expecting too much?

Heres some screen shots:

So you can see here that I have a SQL server database that has done its initial replication.
30 days of short term protection with a 60 minute synchronisation.
screenshot1.PNG
Here you can see that I have the replication create job at 9:12PM, this finished at 9:28PM.
There was a 'Recovery point' scheduled task for 10:00PM which has just disappeared (It's now 10:20PM).
It doesn't throw a warning or appear in the 'completed' section. The recovery point task at 11PM will do the same.
screenshot2.PNG
I do notice that these are 'Recovery Point' tasks not 'Synchronisation' tasks.
The only Synchronisation tasks i have are for a different backup of files elsewhere on my system.
Should the SQL job be scheduling jobs here too?
screenshot3.PNG
No recovery point gets created. I assume because nothing has changed since no synchronisation has taken place?

Am I heading in the right direction or just plain confused? Help?
trebbettesAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pallavi GodseSr. Digital Marketing ExecutiveCommented:
Use the
NORECOVERY 

Open in new window

option when you apply all of the backups except for the last incremental.
0
trebbettesAuthor Commented:
Well my point is there are not any incremental recovery points. So i can't restore the logs / DB to those intervals.
0
BembiCEOCommented:
Synchronisation jobs are from the file system, not form SQL.
SQL backup is different and consists of a full backup + recovery point. Following the transaction backup method, you need to recover a defined state of a db the full backup + the logs until the recovery date / time.

To get a better overview what is saved and what not, you may use the reports in DPM
0
trebbettesAuthor Commented:
DPM 2012 Does Not support Sql Server 2012
DPM 2012 R2 is required to perform these backups properly.
Recommend using Microsoft Azure Backup (DPM).
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
trebbettesAuthor Commented:
No other solution was given that worked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.