[ADSM-L] problem cloning sql server db
2007-12-11 05:51:35
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- [ADSM-L] problem cloning sql server db,
Schaub, Steve <=
|
|
|