ADSM-L

Re: Error restoring SQL database

2007-02-14 11:08:06
Subject: Re: Error restoring SQL database
From: "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 14 Feb 2007 16:46:07 +0100
Hi Andy!
No, the log isn't showing more detail.
Together with support, I have identified the tapes on which the backup
resides. I'm currently running an audit on these tapes. Let's wait for
the results...
Thanks for now!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Andrew Raibeck
Sent: dinsdag 13 februari 2007 14:21
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Error restoring SQL database

If you haven't already looked up the message, you should do so, as it
does provide a little more information.

Are you sure that the ANR0548W message is the *only* related message to
this condition? When searching the actlog, don't do any filtering,
except for the timeframe (I'd start with a timeframe from when the
client operation started through when it ended).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew
Raibeck/Tucson/IBM@IBMUS Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageMan
ager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/13/2007
04:09:59 AM:

> Hi *SM-ers!
> Our SQL guys are trying to restore a SQL database. They receive the 
> following error:
>
> ANS1314E File data currently unavailable on server
>
> In the TSM activity log I see the following message:
>
> ANR0548W Retrieve or restore failed for session 2337961 for node 
> KL1007W9-SQL (TDP MSSQL Win32) processing file space 
> KL1007W9\data\0001
> 2 for file \Zeus\ full stored as Backup - error detected.
>
> Error detected. Right... How do I find what kind of error?
> Thank you very much for your reply!!!
> Kindest regards,
> Eric van Loon
> KLM Royal Dutch Airlines
>
>
> **********************************************************************
> For information, services and offers, please visit our web site:
> http://www.klm.com. This e-mail and any attachment may contain 
> confidential and privileged material intended for the addressee only. 
> If you are not the addressee, you are notified that no part of the 
> e-mail or any attachment may be disclosed, copied or distributed, and 
> that any other action related to this e-mail or attachment is strictly

> prohibited, and may be unlawful. If you have received this e-mail by 
> error, please notify the sender immediately by return e-mail, and 
> delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its

> subsidiaries and/or its employees shall not be liable for the 
> incorrect or incomplete transmission of this e-mail or any 
> attachments, nor responsible for any delay in receipt.
> Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal 
> Dutch Airlines) is registered in Amstelveen, The Netherlands, with 
> registered number 33014286
> **********************************************************************


**********************************************************************
For information, services and offers, please visit our web site: 
http://www.klm.com. This e-mail and any attachment may contain confidential and 
privileged material intended for the addressee only. If you are not the 
addressee, you are notified that no part of the e-mail or any attachment may be 
disclosed, copied or distributed, and that any other action related to this 
e-mail or attachment is strictly prohibited, and may be unlawful. If you have 
received this e-mail by error, please notify the sender immediately by return 
e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), 
its subsidiaries and/or its employees shall not be liable for the incorrect or 
incomplete transmission of this e-mail or any attachments, nor responsible for 
any delay in receipt.
Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch 
Airlines) is registered in Amstelveen, The Netherlands, with registered number 
33014286 
**********************************************************************

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