"maxtransfersize" option in SQL Maintenance Plan

  • fssherwani

    Old Hand

    Points: 305

    Hi All -

    I had log backup jobs setup which started to fail intermittently for last couple of weeks. The SQL server complained of "insufficient system memory". The jobs were backed up as part of maintenance plan

    BUT use of "maxtransfersize" option in the backup script resolved the issue.

    Here is my question.... Is there a way to use "maxtransfersize" option in sql maintenance plan?

    Our environment is SQL 2000 (SP4) on Win 2003 SP2.

    Regards

  • Gazareth

    One Orange Chip

    Points: 27737

    Not good to see you've had no reply in a while!

    I'm trying to do exactly the same thing.

    Anyone? 🙂

  • cvahanan

    Valued Member

    Points: 63

    Have you rsolved this issue.I am having the same issue.Please let me now,if you have the solution for this issue.


    Mayil

  • Jo Pattyn

    SSC-Dedicated

    Points: 31393

    Where did you add the max transfersize? (is this replication?)

    I can't find it in the BOL

    BACKUP LOG { database_name | @database_name_var }

    {

    TO [ ,...n ]

    [ WITH

    [ BLOCKSIZE = { blocksize | @blocksize_variable } ]

    [ [ , ] DESCRIPTION = { 'text' | @text_variable } ]

    [ [ ,] EXPIREDATE = { date | @date_var }

    | RETAINDAYS = { days | @days_var } ]

    [ [ , ] PASSWORD = { password | @password_variable } ]

    [ [ , ] FORMAT | NOFORMAT ]

    [ [ , ] { INIT | NOINIT } ]

    [ [ , ] MEDIADESCRIPTION = { 'text' | @text_variable } ]

    [ [ , ] MEDIANAME = { media_name | @media_name_variable } ]

    [ [ , ] MEDIAPASSWORD = { mediapassword | @mediapassword_variable } ]

    [ [ , ] NAME = { backup_set_name | @backup_set_name_var } ]

    [ [ , ] NO_TRUNCATE ]

    [ [ , ] { NORECOVERY | STANDBY = undo_file_name } ]

    [ [ , ] { NOREWIND | REWIND } ]

    [ [ , ] { NOSKIP | SKIP } ]

    [ [ , ] { NOUNLOAD | UNLOAD } ]

    [ [ , ] RESTART ]

    [ [ , ] STATS [ = percentage ] ]

    ]

    }

  • MarkusB

    SSC-Dedicated

    Points: 37369

    Yes, you can add the maxtransfersize to your maintenance plan.

    Check this article for details:

    http://support.microsoft.com/kb/873482

    [font="Verdana"]Markus Bohse[/font]

  • MarkusB

    SSC-Dedicated

    Points: 37369

    Jo Pattyn (12/3/2007)


    Where did you add the max transfersize? (is this replication?)

    I can't find it in the BOL

    The reason you can't find it in BOL is that this option was added later on in SP3. There's an update available for BOL but I'm not sure if this particular option has been added or not.

    [font="Verdana"]Markus Bohse[/font]

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply