ADSM-L

Re: [ADSM-L] tdpsqlc restore failing

2007-04-06 11:05:04
Subject: Re: [ADSM-L] tdpsqlc restore failing
From: Del Hoobler <hoobler AT US.IBM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 6 Apr 2007 11:03:28 -0400
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.

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