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