ADSM-L

Urgent!! Restoring SQL metadata and data using LANFREE

2002-11-19 08:56:27
Subject: Urgent!! Restoring SQL metadata and data using LANFREE
From: Marc Layne <mlayne AT FARITEC DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 19 Nov 2002 15:42:14 +0200
Hi All

I have the following dilemma..

We are using TDP for SQL version 2.2.1. We are backing up the data via the SAN 
(LANFREE) using the storage agent. 
The SQL metadata is going via the LAN to a diskpool on the TSM server. The 
backups all go through well enough, 
however when attempting a restore or trying to get fileinfo for SQL backups, 
the metadata cannot get retrieved from the diskpool.I can however restore data 
from tape lanfree. 
If the data is migrated to tape and the waitfortapemount box is checked in the 
GUI then the tape is mounted and the metadata retrieved. 
But if I disable the LANFREE path in the dsm.opt file, then the metadata 
filegroup info can be retrieved. IT cannot however retrieve the metadata from 
diskpool and data from tape at the same time  if LANFREE is enabled. 
This is most annoying. I get this behaviour either via the GUI or using tdpsqlc 
from the command line.
TSM server 5.1.1.6
TSM storage agent 5.1.1.6
TDP for SQL 2.2.1

Any help greatly appreciated

Kind Regards
Marc Layne
Faritec (Pty) Ltd
Services Delivery Manager
Tel:     +27 21 762 9702
Fax:     +27 21 762 9737
Cell:    + 27 82 416 9086
Website: www.faritec.co.za
E-mail:   mlayne AT faritec.co DOT za




DISCLAIMER:
This message may contain information which is confidential, private or 
privileged in nature. If you are not the intended recipient, you may not 
peruse, use, disseminate, distribute or copy this message or file which is 
attached to this message. If you have received this message in error, please 
notify the sender immediately by e-mail, facsimile or telephone and thereafter 
return and/or destroy the original message. 

Any views of this communication are those of the sender except where the sender 
specifically states them to be those of Faritec (Proprietary) Limited (Faritec) 
and/or Ebis and Subsidiaries. 

Please note that the recipient must scan this e-mail and any attached files for 
viruses and the like. While we do everything possible to protect information 
from viruses, Faritec accepts no liability of whatever nature for any loss, 
liability, damage or expense resulting directly or indirectly from the access 
and/or downloading of any files which are attached to this e-mail message.