Networker

[Networker] Recover SQL data using scanner

2006-01-19 16:50:54
Subject: [Networker] Recover SQL data using scanner
From: John Hope-Bailie <Johnhb AT CHANNELDATA.CO DOT ZA>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 19 Jan 2006 23:46:07 +0200
Hi all.

 

I have a networker tape with a corrupted label.  When I run scanner,  it
synchronises with the chunks after an initial error message and then
proceeds.  I suspect that it was caused by the tape drive being reset
during the backup, which causes it to rewind and then continue writing
data.   As a result, the tape label and the first, say, 50 filemarks are
gone.

 

I need to recover a SQL DB off these tapes if possible.   I know that
you can use scanner to extract a saveset and redirect this through usam
to restore filesystem-based data.

 

Does anyone know if you can redirect data through nsrsqlrc.exe (or
anything else) to recover a SQL database 

 

Alternately I could possibly write/clone the saveset to a correctly
labelled tape (or a file device) and recover from there.

 

Does anyone know how to do this ?

 

Regards,

 

John Hope-Bailie

johnhb AT channeldata.co DOT za

 

 

 

 


To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the
body of the email. Please write to networker-request AT listserv.temple DOT edu 
if you have any problems
wit this list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

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