Kjell,
The machine that restores MUST be at the same level or newer.
Thanks,
Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 04/06/2007
10:42:58 AM:
> 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.
|