Sorry - hit send before I finished the subject earlier Tsm server 5.2.7.1
Tsm client 5.3.4.0 Client on windows 2003 r2 sp2 x64 Tdp 5.3.3.0 Sql 2005 Anyone know what these error messages mean? Our dba's moved a db from a sql2000 to a sql2005 server over the weekend, now my clone script for creating a data warehouse copy wont work. The restore is running on the same machine/instance it backed up from minutes before: Beginning full restore of backup object Carekey, 1 of 1, to database Carekey_DSS Full: 13 Read: 13631488 Written: 30720 Rate: 29.82 Kb/Sec Full: 7 Read: 15728640 Written: 30720 Rate: 14.95 Kb/Sec Full: 7 Read: 15728640 Written: 30720 Rate: 9.98 Kb/Sec Full: 7 Read: 15728640 Written: 30720 Rate: 7.49 Kb/Sec Full: 7 Read: 15728640 Written: 30720 Rate: 5.99 Kb/Sec Full: 7 Read: 15728640 Written: 30720 Rate: 4.99 Kb/Sec Full: 7 Read: 15728640 Written: 30720 Rate: 4.28 Kb/Sec Waiting for TSM server..... Full: 8 Read: 16777216 Written: 30720 Rate: 2.73 Kb/Sec Full: 8 Read: 16777216 Written: 30720 Rate: 2.61 Kb/Sec Restore of Carekey failed. [Microsoft][ODBC SQL Server Driver][SQL Server]The file 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\Carekey BoardSearch' cannot be overwritten. It is being used by database 'Carekey'. [Microsoft][ODBC SQL Server Driver][SQL Server]File 'sysft_Carekey BoardSearch' cannot be restored to 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\Carekey BoardSearch'. Use WITH MOVE to identify a valid location for the file. [Microsoft][ODBC SQL Server Driver][SQL Server]The file 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\Carekey ConceptSearch' cannot be overwritten. It is being used by database 'Carekey'. [Microsoft][ODBC SQL Server Driver][SQL Server]File 'sysft_Carekey ConceptSearch' cannot be restored to 'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData\Carekey ConceptSearch'. Use WITH MOVE to identify a valid location for the file. [Microsoft][ODBC SQL Server Driver][SQL Server]Problems were identified while planning for the RESTORE statement. Previous messages provide details. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally. Here's the command I'm using: set tdp_dir="C:\Program Files\Tivoli\TSM\TDPSQL" set logfile=sql_full_%dayofweek%.log set from_dbname=Carekey set to_dbname=Carekey_DSS set to_logical=ckdbny_index,ckdbny_text,ckdbny_data,ckdbny_log set to_physical=f:\data\Carekey_DSS_Index.NDF,f:\data\Carekey_DSS_text_Data. NDF,f:\data\Carekey_DSS_Data.MDF,g:\logs\Carekey_DSS_Log.LDF set optfile=sqlserver.opt tdpsqlc restore %from_dbname% full /tsmoptfile=sqlserver.opt /into=%to_dbname% /relocate=%to_logical% /to=%to_physical% /replace >> %logfile% Steve Schaub Systems Engineer, Windows Blue Cross Blue Shield of Tennessee 423-535-6574 (desk) 423-785-7347 (mobile) Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
