Update on this issue.
I am happy to report that NetWorker will, in fact, mount tapes which
have no headers. It spends some time synhronising with the blocks it
finds and then the tape is ready for use.
I used mminfo to check the tape position of the data I needed.
(mediafile, mediarec).
Then using scanner I verified that starting filemark of the tape was
lower than the tape position of the data (i.e. the data was on the tape
and had not been overwritten)
Then restored the data.
John Hope-Bailie
E-mail: johnhb AT channeldata.co DOT za
-----Original Message-----
From: Legato NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
On Behalf Of John Hope-Bailie
Sent: 19 January 2006 11:46 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] Recover SQL data using scanner
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
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
|