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