The DPM database on my primary DPM server is 30GB.  The tbl_TE_TaskTrail 
table is 23GB and contains data back to 2008.  Is it possible to prune this 
table to reduce the database size?

Thanks
Richard

        I am assuming you are using DPM 2007 SP1. tbl_TE_TaskTrail is 
supposed to have the entries only for the last one month tasks. Looks like 
that the Garbage collection is not happening. Can you please make sure that 
you have DPM 2007 SP1 and its latest 
QFE(http://www.microsoft.com/downloads/details.aspx?FamilyID=74ac7461-dbfe-4bc1-85a2-4d2948f30e42) 
installed on your DPM server? The Garbage collection job runs at 12:00AM, 
next day these rows should be deleted. Post this you can run SQL DBCC 
command to shrink the DPM database size 
(http://msdn.microsoft.com/en-us/library/ms190488.aspx).

Thanks,
Praveen D [MSFT]
This posting is provided “AS IS” with no warranties, and confers no rights.

"Richard Skinner" <RichardSkinner@discussions.microsoft.com> wrote in 
message news:03A6982B-D9C2-4EA3-ADED-740DD42F5155@microsoft.com...
> The DPM database on my primary DPM server is 30GB.  The tbl_TE_TaskTrail
> table is 23GB and contains data back to 2008.  Is it possible to prune 
> this
> table to reduce the database size?
>
> Thanks
> Richard 

Yes, I'm running DPM 2007 SP1.  Add/Remove programs shows I have the 
following KBs installed: 976542, 970868 and 959605.  Is there any way I can 
manually run the garbage collection task?

Thanks

"Praveen D [MSFT]" wrote:

>         I am assuming you are using DPM 2007 SP1. tbl_TE_TaskTrail is 
> supposed to have the entries only for the last one month tasks. Looks like 
> that the Garbage collection is not happening. Can you please make sure that 
> you have DPM 2007 SP1 and its latest 
> QFE(http://www.microsoft.com/downloads/details.aspx?FamilyID=74ac7461-dbfe-4bc1-85a2-4d2948f30e42) 
> installed on your DPM server? The Garbage collection job runs at 12:00AM, 
> next day these rows should be deleted. Post this you can run SQL DBCC 
> command to shrink the DPM database size 
> (http://msdn.microsoft.com/en-us/library/ms190488.aspx).
> 
> Thanks,
> Praveen D [MSFT]
> This posting is provided “AS IS” with no warranties, and confers no rights.
> 
> "Richard Skinner" <RichardSkinner@discussions.microsoft.com> wrote in 
> message news:03A6982B-D9C2-4EA3-ADED-740DD42F5155@microsoft.com...
> > The DPM database on my primary DPM server is 30GB.  The tbl_TE_TaskTrail
> > table is 23GB and contains data back to 2008.  Is it possible to prune 
> > this
> > table to reduce the database size?
> >
> > Thanks
> > Richard 
> 
> .
> 

    Sorry for the delayed reply, You can find a Scheduled task registered in 
DPM Database's SQL server under SQL Server Agent -> Jobs with the task name 
"97AB8BC2-B697-48db-AD1F-9850F1163B7E". Right click it and select "Start Job 
At Step". Once this job is succeeded you should be able to find the reduced 
number of Task trails.

Thanks,
Praveen D [MSFT]
This posting is provided “AS IS” with no warranties, and confers no rights.

"Richard Skinner" <RichardSkinner@discussions.microsoft.com> wrote in 
message news:07E47EC8-E0BB-4F1E-B044-4DAA6F841224@microsoft.com...
> Yes, I'm running DPM 2007 SP1.  Add/Remove programs shows I have the
> following KBs installed: 976542, 970868 and 959605.  Is there any way I 
> can
> manually run the garbage collection task?
>
> Thanks
>
> "Praveen D [MSFT]" wrote:
>
>>         I am assuming you are using DPM 2007 SP1. tbl_TE_TaskTrail is
>> supposed to have the entries only for the last one month tasks. Looks 
>> like
>> that the Garbage collection is not happening. Can you please make sure 
>> that
>> you have DPM 2007 SP1 and its latest
>> QFE(http://www.microsoft.com/downloads/details.aspx?FamilyID=74ac7461-dbfe-4bc1-85a2-4d2948f30e42)
>> installed on your DPM server? The Garbage collection job runs at 12:00AM,
>> next day these rows should be deleted. Post this you can run SQL DBCC
>> command to shrink the DPM database size
>> (http://msdn.microsoft.com/en-us/library/ms190488.aspx).
>>
>> Thanks,
>> Praveen D [MSFT]
>> This posting is provided “AS IS” with no warranties, and confers no 
>> rights.
>>
>> "Richard Skinner" <RichardSkinner@discussions.microsoft.com> wrote in
>> message news:03A6982B-D9C2-4EA3-ADED-740DD42F5155@microsoft.com...
>> > The DPM database on my primary DPM server is 30GB.  The 
>> > tbl_TE_TaskTrail
>> > table is 23GB and contains data back to 2008.  Is it possible to prune
>> > this
>> > table to reduce the database size?
>> >
>> > Thanks
>> > Richard
>>
>> .
>>