Hi

I use DPM for backup my SQL Server 2005 and MS Exchange 2007.

When implementing backup Exchange transaction logs is truncated, but when
SQL Server is not happening and I have to delete logs manually. Why?
How do I configure DPM, to SQL logs were cut, too?

--

---------------------------
wishes
Dmitry

Hi,

Have you scheduled to take incremental backups for the SQL Server databases?
Express full backups do not truncate logs. Incremental backups which are
infact log backups truncate logs.

--
Thanks,
Hitesh Sharma [MSFT]
This posting is provided "AS IS" with no warranties, and
confers no rights.

Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm
"Dmitry Chelyshkov" <chell@elorent.com> wrote in message
news:uxAo$0bYKHA.3712@TK2MSFTNGP06.phx.gbl...
> Hi
>
> I use DPM for backup my SQL Server 2005 and MS Exchange 2007.
>
> When implementing backup Exchange transaction logs is truncated, but when
> SQL Server is not happening and I have to delete logs manually. Why?
> How do I configure DPM, to SQL logs were cut, too?
>
> --
>
> ---------------------------
> wishes
> Dmitry

Hitesh,

Thank you for your response as this also answers my question. I have a
follow-up question. Does this mean that a new DMP log file is created after
each DPM log backup or does this work like the express full backups and just
look at byte level changes?

"Hitesh Sharma[MSFT]" wrote:

> Hi,
>
> Have you scheduled to take incremental backups for the SQL Server databases?
> Express full backups do not truncate logs. Incremental backups which are
> infact log backups truncate logs.
>
> --
> Thanks,
> Hitesh Sharma [MSFT]
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
>
> Use of included script samples are subject to the terms
> specified at http://www.microsoft.com/info/cpyright.htm
> "Dmitry Chelyshkov" <chell@elorent.com> wrote in message
> news:uxAo$0bYKHA.3712@TK2MSFTNGP06.phx.gbl...
> > Hi
> >
> > I use DPM for backup my SQL Server 2005 and MS Exchange 2007.
> >
> > When implementing backup Exchange transaction logs is truncated, but when
> > SQL Server is not happening and I have to delete logs manually. Why?
> > How do I configure DPM, to SQL logs were cut, too?
> >
> > --
> >
> > ---------------------------
> > wishes
> > Dmitry
>
>
> .
>

I have DPM 2010 RC setup backing up SQL Server 2005, as you have suggested,
with Synchronization taking place every 45 minutes and the express full
backup once a day.

The problem is that the transaction logs are not being truncated.

Any suggestions?

This is a fresh load of DPM 2010 RC on Server 2008 R2 Standard x64.



"Hitesh Sharma[MSFT]" wrote:

> Hi,
>
> Have you scheduled to take incremental backups for the SQL Server databases?
> Express full backups do not truncate logs. Incremental backups which are
> infact log backups truncate logs.
>
> --
> Thanks,
> Hitesh Sharma [MSFT]
> This posting is provided "AS IS" with no warranties, and
> confers no rights.
>
> Use of included script samples are subject to the terms
> specified at http://www.microsoft.com/info/cpyright.htm
> "Dmitry Chelyshkov" <chell@elorent.com> wrote in message
> news:uxAo$0bYKHA.3712@TK2MSFTNGP06.phx.gbl...
> > Hi
> >
> > I use DPM for backup my SQL Server 2005 and MS Exchange 2007.
> >
> > When implementing backup Exchange transaction logs is truncated, but when
> > SQL Server is not happening and I have to delete logs manually. Why?
> > How do I configure DPM, to SQL logs were cut, too?
> >
> > --
> >
> > ---------------------------
> > wishes
> > Dmitry
>
>
> .
>