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