Eric,

There is no way to set a max file size for Data Protection for SQL.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 01/18/2010
01:50:14 PM:

> [image removed]
>
> DP for SQL Server backup file size
>
> Loon, EJ van - SPLXM
>
> to:
>
> ADSM-L
>
> 01/18/2010 01:51 PM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> Hi TSM-ers!
> Today and last weekend we encounted a filled recovery log on two
> different servers. It looks like both of them were caused by a
> pinned recoverylog. TSM started one incremental after the other, but
> could not free up space. I had to bounce both servers.
> I found two parameters to prevent the log from getting pinned
> (THROUGHPUTDATATHRESHOLD and THROUGHPUTTIMETHRESHOLD) but I found no
> recommended values...
> Another document talks about limiting the size of files written to
> the diskpool. Large files written to a fragmented diskpool tend to
> pin the log too. I know my SQL clients are the only clients writing
> very large backup files. I cannot find a DP for SQL Server parameter
> to tune this. I know you can set the file size in the DP for Oracle
> and SAP client. Is this also somehow possible in the SQL Server client?
> Thanks in advance for any reply!
> Kind regards,
> Eric van Loon