Dear friends
Before open a call in Microsoft, could you see if it's possible to solve
this mistery ...? :)
We are having a remote backup fail for SQLServer 2000 sp4, build 2195.
The error list is below:
04/20/2007 09:00:05 Request : DIFF BACKUP
04/20/2007 09:00:05 Database Input List : *
04/20/2007 09:00:05 Group Input List : -
04/20/2007 09:00:05 File Input List : -
04/20/2007 09:00:05 Number of Buffers : 3
04/20/2007 09:00:05 Buffer Size : 1024
04/20/2007 09:00:05 Number of SQL Buffers : 1
04/20/2007 09:00:05 SQL Buffer Size : 1024
04/20/2007 09:00:05 Number of Stripes specified : 1
04/20/2007 09:00:05 Estimate : 20
04/20/2007 09:00:05 Truncate Log? : -
04/20/2007 09:00:05 Wait for Tape Mounts? : Yes
04/20/2007 09:00:05 TSM Options File : i:\tsmdata\dsm.opt
04/20/2007 09:00:05 TSM Nodename Override : -
04/20/2007 09:00:05 Sqlserver : SBCDF049\INST1
04/20/2007 09:00:05
04/20/2007 09:00:17 Backup of model failed.
04/20/2007 09:00:17 ACO5403E The configuration of the Virtual Device Set
could not be obtained.
04/20/2007 09:00:18 Backup of Northwind failed.
04/20/2007 09:00:18 ACO5403E The configuration of the Virtual Device Set
could not be obtained.
04/20/2007 09:00:18 Backup of OEAdmin failed.
04/20/2007 09:00:18 ACO5403E The configuration of the Virtual Device Set
could not be obtained.
04/20/2007 09:00:19 Backup of OEModels failed.
04/20/2007 09:00:19 ACO5403E The configuration of the Virtual Device Set
could not be obtained.
04/20/2007 09:00:20 Backup of OEModels_Stage failed.
04/20/2007 09:00:20 ACO5403E The configuration of the Virtual Device Set
could not be obtained.
04/20/2007 09:00:20 Backup of OVSD failed.
04/20/2007 09:00:20 ACO5403E The configuration of the Virtual Device Set
could not be obtained.
04/20/2007 09:00:21 Backup of OVSD_APOIO failed.
04/20/2007 09:00:21 ACO5403E The configuration of the Virtual Device Set
could not be obtained.
04/20/2007 09:00:21 Backup of pubs failed.
04/20/2007 09:00:21 ACO5403E The configuration of the Virtual Device Set
could not be obtained.
04/20/2007 09:00:21 Total SQL backups selected: 10
04/20/2007 09:00:21 Total SQL backups attempted: 8
04/20/2007 09:00:21 Total SQL backups completed: 0
04/20/2007 09:00:21 Total SQL backups excluded: 2
04/20/2007 09:00:21 Throughput rate: 0.00 Kb/Sec
04/20/2007 09:00:21 Total bytes transferred: 0
04/20/2007 09:00:21 Elapsed processing time: 4.61 Secs
04/20/2007 09:00:21 ACO0151E Errors occurred while processing the
request.
04/20/2007 09:00:21 ACO0151E Errors occurred while processing the
request.
We found this about the ACO5403E error:
Problem
With the SQL server 2005 the backup can still terminate with "ACO5403E
The configuration of the Virtual Device Set could not be obtained."
Solution
Check the application event log for an entry, similar to this:
BackupVirtualDeviceSet::Initialize; Request large buffers;
TDPSQL-000009D8-0000; 0x8007000e (Not enough storage is available to
complete this operation.).
The SQL Server 2005 allocates the MAXTRANSFERSIZE
(sqlbuffers*sqlbuffersize) from the SQL Server buffer pool instead from
the MemToLeave area.
To solve this issue reduce either the number of SQLBUFFers or the
SQLBUFFERSIze.
When /sqlbuffers is set to 0, SQL determines how many buffers should be
used.
A restore of the SQL server is no longer required.
But we are using SQLServer 2000 yet...
Do you think that is really possible could be the sqlbuffersize or the
MemToLeave? How to change these stuffs? Command Line? DOS? Which the
command?
Thanks in advance
Davi Cabral
MS Sql Server LazyDBA home page