Eric, There is no way to set a max file size for Data Protection for SQL.
Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> 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" <[email protected]> > > 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
