Is it possible to backup up multiple mssql server instances in one command?
Is it possible to backup up multiple mssql server instances in one command? Something like: tdpsqlc backup * full /tsmoptfile=%sql_dir%\dsm.opt /sqlserver=.\D01 .\BD1 /logfile=c:\var\log\tsm\sqlfull.log >> c:\var\log\tsm\sqlsched.log (I know this one doesn't work, but something similar?) Or is the only solution to have 2 client nodes, one for each instance?? Best wishes Kjell Kaspersen
restore error - '': file space does not exist.
Hi I try to run a restore of a folder/partition to a different server: rest -fromnode= /home/ -subdir=yes -pitd=02/27/2005 /home/ But, this fails after restoring parts of this folder: Total number of objects restored:29,664 Total number of objects failed: 0 Total number of bytes transferred: 1.18 GB Data transfer time: 131.75 sec Network data transfer rate:9,460.87 KB/sec Aggregate data transfer rate: 4,090.21 KB/sec Elapsed processing time: 00:05:04 ANS4000E Error processing '': file space does not exist. Does anyone know what might cause this? Best wishes Kjell Kaspersen
Re: restore error - '': file space does not exist.
fromserver: Red Hat Linux release 7.3 (Valhalla) LABEL=/home /home ext3defaults1 2 toserver: Red Hat Enterprise Linux ES release 3 (Taroon Update 4) /dev/md8/home ext3defaults1 2 Does this mean "all bets are off"? ;-) best wishes Kjell Kaspersen Richard Sims wrote: When posting, please include vital details: platform type(s), software levels. We've seen this before where the From and To platform types and or file system types were not the same. All bets are off when you attempt something like that. Note that -FROMNode can be problematic if this was not in conjunction with SET Access on the original client; otherwise you really want to use the -VIRTUALNodename=___ option. Richard Sims On Mar 11, 2005, at 2:35 PM, Kjell Kaspersen wrote: Hi I try to run a restore of a folder/partition to a different server: rest -fromnode= /home/ -subdir=yes -pitd=02/27/2005 /home/ But, this fails after restoring parts of this folder: Total number of objects restored:29,664 Total number of objects failed: 0 Total number of bytes transferred: 1.18 GB Data transfer time: 131.75 sec Network data transfer rate:9,460.87 KB/sec Aggregate data transfer rate: 4,090.21 KB/sec Elapsed processing time: 00:05:04 ANS4000E Error processing '': file space does not exist. Does anyone know what might cause this? Best wishes Kjell Kaspersen
Re: restore error - '': file space does not exist.
Thank you for the information :-) Hm, I have trouble understanding *why* it has to be like this, but... What does a person then do when this server crashes, and sees a golden opportunity to install a new with a more uptodate operating system? Files cannot be restored? /kjell Richard Sims wrote: Most likely. That's the same kind of situation the previous customer experienced, with different flavors of Linux. You're probably best off restoring to a work area on the system which originated the backup, and then transfer that data to the destination system. Richard Sims "Linux is only free if your time has no value." - Jamie Zawinsky On Mar 12, 2005, at 1:01 PM, Kjell Kaspersen wrote: fromserver: Red Hat Linux release 7.3 (Valhalla) LABEL=/home /home ext3defaults 1 2 toserver: Red Hat Enterprise Linux ES release 3 (Taroon Update 4) /dev/md8/home ext3defaults 1 2 Does this mean "all bets are off"? ;-)
tdpsqlc restore failing
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\1BA8 /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.