Arlene,
> We recently migrated from SQL6.5 to SQL7 and have been using Arcserve NT
> version with (SQL agent) to back up the databases. With SQL6.5 we were
> successful however, we encounter the following error "Configured value
> of backup buffer size is invalid". I can not find a resolution.
> acame
...@vcai.com
Q. Should I amend the SQL Server "Backup Buffer Size"? Why am I getting an
error about it in SQL 7.0 with a 3rd party backup tool?
(v1.1 2000.01.19)
A. This parameter only applies to SQL 6.x. Under most circumstances it
doesn't need to be changed and even then you would need to test in your own
environment to see whether it made any difference in your particular disk/tape
subsystem. There are too many variables of disk speed, raid controller
buffers, tape speed, tape blocksize etc. to say whether increasing this area of
memory that SQL uses will make any difference.
Example figures are below taken from a large system doing a dump to 3 striped
DLT 7000 drives from a very fast disk subsystem with 40 spindles and varying
the "backup buffer size" parameter. The figures don't change that much, but in
general lower numbers of buffers were better.
1 01:12:00.687
2 01:11:28.860
3 01:11:50.969
4 01:13:18.859
5 01:15:01.750
6 01:17:15.594
7 01:16:41.516
8 01:16:11.469
If you get an error about "Configured value of backup buffer size is invalid"
then you are on SQL 7 and using a 3rd party backup agent. SQL 7 does not have
this parameter any longer. Any 3rd party agent that has an error with this
needs to be upgraded to a SQL 7 aware version.
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please reply only to newsgroups)
SQL FAQ (412 entries) see
sqlfaq.zip in lib 7 (SQL Public) @
http://forumsb.compuserve.com/vlforums/UK/default.asp?SRV=MSDevApps
or www.ntfaq.com/sql.html (+ ntfaq download)
or http://www.sql-server.co.uk
