Kjell, The machine that restores MUST be at the same level or newer.
Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <[email protected]> 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.
