DPM 2012 R2 - reduce log size

Hi All,

I have DPM 2012 R2 CU6, SQL 2012 in HA group.

DPM backups daily a TFS DBs with 4 hours sync interval.

Sadly my problem is that log file quickly run out of memory ... every 7-8 days.

I specified 50 GB max size for the log, the mdf is 50 too.

Is there an option to clear up the log file space? If I manually create log backup, then the space is cleared, but I prefer to automate this.

My DPM backups the secondary replica.

June 22nd, 2015 4:31am

You can setup a maintenance plan jobs within SQL, to perform a backup of the log files via SQL maintenance plan will clear the log space

You can set the backup jobs via SQL Studio 

https://msdn.microsoft.com/en-GB/library/ms191002.aspx

Free Windows Admin Tool Kit Click here and download it now
June 22nd, 2015 4:52am

hi Andrew,

i did a maintenance plan but i wanted somehow the DPM to do this for me.

Now i make transaction log backups on the secondary replica and it works.... so this will be my workaround.

Thank you

June 23rd, 2015 3:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics