I've been trying to optimise the way we do our TDP for SQL backups but have
hit a snag when attempting to use multiple stripes.

Specifying a /STIPES value of greater than one works on all my clients
except for one, which just happens to be a clustered SQL Server.

I get the same error through the GUI or from the command line.

Below are the output from the command line, the contents of the log file
and also the corresponding error from the SQL Server error log.

If I specify /STRIPES=1, it all works. I've tried adjusting the
/SQLBuffers, /SQLBuffersize, /Buffers and /Buffersize parameters but to no
avail.

I can perform backups to multiple *disk* devices from Enterprise Manager.

Anybody got any ideas what's going wrong?

Regards
Neil Schofield




D:\TSM\TDPSql>tdpsqlc backup PRD diff /stripes=4 /tsmoptfile=V:
\TSM\TDPSQL\dsm.o
pt

Tivoli Storage Manager
Tivoli Data Protection for Microsoft SQL Server
Version 2, Release 2, Level 0.01
(C) Copyright IBM Corporation 1997, 2001. All rights reserved.


Starting SQL database backup...


Beginning difffull backup for database PRD, 1 of 1.
Full: 0   Read: 0  Written: 0  Rate: 0.00 Kb/Sec
Backup of PRD failed.
ACO5403E The configuration of the Virtual Device Set could not be obtained.


Total SQL backups selected:               1
Total SQL backups attempted:              1
Total SQL backups completed:              0
Total SQL backups excluded:               0

Throughput rate:                          0.00 Kb/Sec
Total bytes transferred:                  0
Elapsed processing time:                  0.61 Secs

ACO0151E Errors occurred while processing the request.

The TDPSQL.LOG contains the following:

27-02-2002 23:26:15
============================================================
=============
=============
27-02-2002 23:26:15
============================================================
=============
=============
27-02-2002 23:26:15 Request                       : DIFF BACKUP
27-02-2002 23:26:15 Database Input List           : PRD
27-02-2002 23:26:15 Group Input List              : -
27-02-2002 23:26:15 File Input List               : -
27-02-2002 23:26:15 Number of Buffers             : 3
27-02-2002 23:26:15 Buffer Size                   : 1024
27-02-2002 23:26:15 Number of SQL Buffers         : 0
27-02-2002 23:26:15 SQL Buffer Size               : 1024
27-02-2002 23:26:15 Number of Stripes specified   : 4
27-02-2002 23:26:15 Estimate                      : 90
27-02-2002 23:26:15 Truncate Log?                 : -
27-02-2002 23:26:15 Wait for Tape Mounts?         : Yes
27-02-2002 23:26:15 TSM Options File              : V:\TSM\TDPSQL\dsm.opt
27-02-2002 23:26:15 TSM Nodename Override         : -
27-02-2002 23:26:15 Sqlserver                     : SAPDB
27-02-2002 23:26:15
27-02-2002 23:26:17 ACO5403E The configuration of the Virtual Device Set
could n
ot be obtained.
27-02-2002 23:26:17 Backup of PRD failed.
27-02-2002 23:26:17 ACO5403E The configuration of the Virtual Device Set
could n
ot be obtained.
27-02-2002 23:26:17 Total SQL backups selected:               1
27-02-2002 23:26:17 Total SQL backups attempted:              1
27-02-2002 23:26:17 Total SQL backups completed:              0
27-02-2002 23:26:17 Total SQL backups excluded:               0
27-02-2002 23:26:17 Throughput rate:                          0.00 Kb/Sec
27-02-2002 23:26:17 Total bytes transferred:                  0
27-02-2002 23:26:17 Elapsed processing time:                  0.61 Secs
27-02-2002 23:26:17 ACO0151E Errors occurred while processing the request.

The SQL Server Errorlog contains the following:

2002-02-27 23:26:16.64 kernel   BackupVirtualDeviceSet::Initialize:
SetConfiguration failure on backup device 'TDPSQL-0000030E-0000'. Operating
system error -2147024888(error not found).





The information in this e-mail is confidential and may also be legally
privileged. The contents are intended for recipient only and are subject
to the legal notice available at http://www.keldagroup.com/email.htm
Yorkshire Water Services Limited
Registered Office Western House Halifax Road Bradford BD6 2SZ
Registered in England and Wales No 2366682