Urgent!! Restoring SQL metadata and data using LANFREE
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: [EMAIL PROTECTED] 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.
Re: Urgent!! Restoring SQL metadata and data using LANFREE
Marc, Can you be more specific on what error you are seeing? For example, what error message do you get when you issue the following command: TDPSQLC QUERY TSM * FULL /FILEINFO Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Never cut what can be untied. - Commit yourself to constant improvement. 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
FW: Re: Urgent!! Restoring SQL metadata and data using LANFREE
Hi Del The specific error we are getting is as follows: 11/19/2002 12:56:50 ANR1421W (Session: 3523, Origin: DWHSTAGE) Read access denied for volume E:\TSMDATA\SERVER1\MSSQLMETA.DSM - volume offline. This volume is not offline. Also If i disable the LANFREE then I can retrieve the metadata from the diskpool. It almost seems that although the management class controls the backup process, the restore has no way of knowing that it should requestthe metadat across the LAN, when it is getting the actual DATA from the tapes on the SAN. 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: [EMAIL PROTECTED] 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.
Re: FW: Re: Urgent!! Restoring SQL metadata and data using LANFREE
Issue command update volume E:\TSMDATA\SERVER1\MSSQLMETA.DSM acc=readonly or readwrite depending if you want if wrote to and read from or only read from. Thanks, Robert Rippy From: Marc Layne [EMAIL PROTECTED] on 11/19/2002 11:19 AM Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: FW: Re: Urgent!! Restoring SQL metadata and data using LANFREE Hi Del The specific error we are getting is as follows: 11/19/2002 12:56:50 ANR1421W (Session: 3523, Origin: DWHSTAGE) Read access denied for volume E:\TSMDATA\SERVER1\MSSQLMETA.DSM - volume offline. This volume is not offline. Also If i disable the LANFREE then I can retrieve the metadata from the diskpool. It almost seems that although the management class controls the backup process, the restore has no way of knowing that it should requestthe metadat across the LAN, when it is getting the actual DATA from the tapes on the SAN. 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: [EMAIL PROTECTED] 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.
Re: FW: Re: Urgent!! Restoring SQL metadata and data using LANFREE
Marc, This could be a bug. It's hard to tell without looking more closely at the configuration. The Storage Agent should be going after the data over the LAN. Please call IBM support so they can assist you. Thanks, Del Del Hoobler IBM Corporation [EMAIL PROTECTED] - Never cut what can be untied. - Commit yourself to constant improvement. === Hi Del The specific error we are getting is as follows: 11/19/2002 12:56:50 ANR1421W (Session: 3523, Origin: DWHSTAGE) Read access denied for volume E:\TSMDATA\SERVER1\MSSQLMETA.DSM - volume offline. This volume is not offline. Also If i disable the LANFREE then I can retrieve the metadata from the diskpool. It almost seems that although the management class controls the backup process, the restore has no way of knowing that it should requestthe metadat across the LAN, when it is getting the actual DATA from the tapes on the SAN.