Dan, Yes, it can have a space. Use quotes around the database name when specifying Data Protection for SQL commands. For example:
================================================================================ C:\Program Files\Tivoli\TSM\TDPSql>tdpsqlc backup "Name with a space" full IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server Version 5, Release 2, Level 1.06 (C) Copyright IBM Corporation 1997, 2006. All rights reserved. Starting SQL database backup... Beginning full backup for database Name with a space, 1 of 1. Full: 0 Read: 2182896 Written: 2182896 Rate: 1,403.38 Kb/Sec Backup of Name with a space completed successfully. Total SQL backups selected: 1 Total SQL backups attempted: 1 Total SQL backups completed: 1 Total SQL backups excluded: 0 Total SQL backups inactivated: 0 Throughput rate: 1,402.46 Kb/Sec Total bytes transferred: 2,182,896 Elapsed processing time: 1.52 Secs ============================================================================= Thanks, Del ---------------------------------------------------- Del Hoobler Tivoli Storage Manager Development IBM Corporation "ADSM: Dist Stor Manager" <[email protected]> wrote on 10/27/2006 12:19:50 PM: > I have a very simple question, when adding the name for a SQL database > in the TDP for SQL's cmd file can the database have a space in the name. > If not can you add quotes or any other sort of marker to allow it. > > > > Thank you > > > > Dan Cyr
