May 3, 2007 at 8:13 am
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
October 18, 2007 at 5:42 am
Not good to see you've had no reply in a while!
I'm trying to do exactly the same thing.
Anyone? 🙂
November 27, 2007 at 9:03 am
Have you rsolved this issue.I am having the same issue.Please let me now,if you have the solution for this issue.
Mayil
December 3, 2007 at 10:57 am
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 ] ]
]
}
December 3, 2007 at 1:34 pm
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]
December 3, 2007 at 1:36 pm
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply