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