ADSM-L

[ADSM-L] tdpsqlc restore failing

2007-04-06 10:43:32
Subject: [ADSM-L] tdpsqlc restore failing
From: Kjell Kaspersen <kjell AT BASEFARM DOT NO>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 6 Apr 2007 16:42:58 +0200
Hi
I try to restore an mssql database backed up at one server, to another.
But it fails, see output below.
Ony difference is that the server where database was backed up from,
runs windows 2003 std x64, with tdpsql klient version 5.3.3.0.
Server where I try to restore to, runs windows 2003 std and tdpsql
client version 5.2.1.0.
Could those differences be an issue? I've done similar earlier without
problems.

I cannot understand why it will try and replace G:\SQL
Server\q500_log.ldf ??

Thank you

Best wishes
Kjell Kaspersen


tdpsqlc restore q500
/fromsqlserver=q5-db01
/object=20070319181808\00001BA8
/into=restore
/relocate=q500_Data1,q500_log,q500_Data2
/to=e:\db\restore_Data1.mdf,g:\db\restore_log.ldf,e:\db\re
store_Data2.ndf
/replace
/recover=no

IBM Tivoli Storage Manager for Databases:
Data Protection for Microsoft SQL Server
Version 5, Release 2, Level 1.0
(C) Copyright IBM Corporation 1997, 2003. All rights reserved.

ACO5057I The C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.log log file was
pruned s
uccessfully.

Please enter the password for node Q5-DB01.STH.BASEFARM.NET_MSSQL:

*****
Starting Sql database restore...

Querying Tivoli Storage Manager server for a list of database backups,
please wa
it...

Restoring metadata ...


Beginning full restore of backup object q500, 1 of 1,
  to database restore
Full: 0   Read: 0  Written: 0  Rate: 0.00 Kb/Sec
Waiting for TSM
server..........................................................
................................................................................
................................................................................
.....................................
Full: 1   Read: 3145728  Written: 5632  Rate: 0.02 Kb/Sec
Restore of q500 failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]The file 'G:\SQL
Server\q500_log.
ldf' cannot be overwritten.  It is being used by database 'Q500'.
[Microsoft][ODBC SQL Server Driver][SQL Server]File 'q500_log' cannot be
restore
d to 'G:\SQL Server\q500_log.ldf'. Use WITH MOVE to identify a valid
location fo
r the file.
[Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is
terminating a
bnormally.


Total database backups inspected:               1
Total database backups requested for restore:   1
Total database backups restored:                0
Total database skipped:                         0

Throughput rate:                                0.02 Kb/Sec
Total bytes transferred:                        5,632
Elapsed processing time:                        261.48 Secs

ACO0151E Errors occurred while processing the request.

<Prev in Thread] Current Thread [Next in Thread>