RE: [OT] ms backup tape problem

["Dr John Tankard" <john@xxxxxxx>]

> Same service pack level as when the backup was done?

Yes
> ]
> Does the tape device show up under "Removable Media" in 
> computer management?

I did not think of that... Yes its there should I try to monut it


> 
> I am grasping at straws, but it sounds like you are too...

Yes I am, sql backup reads the tape and reports the session it wont
read
the data because its not a sql backup, I am now getting a bit more
happy
that the data is there.

There is one other thing I did.... I temporaly installd arcserve to
copy
a arcserve tape before it put it into the server, I then un-installed
arcserve, I wonder if that has screwed it up


John



> 
> Glenn Sullivan, MCSE+I  MCDBA
> David Clark Company Inc.
> 
> 
> -----Original Message-----
> From: Dr John Tankard [mailto:john@xxxxxxx]
> Sent: Wednesday, November 06, 2002 3:13 PM
> To: ukha_d@xxxxxxx
> Subject: RE: [ukha_d] [OT] ms backup tape problem
> 
> 
> Yep it instantly returns, again the tape drive does not move. 
> I am just tryint to read the tape using backup in sql server 
> that is looking at the tape at the momemt it's a dds4 so it 
> might take some time, I know I cannt use it to restore but if 
> it finds the session I will be a bit happier
> 
> John
> 
> > -----Original Message-----
> > From: Sullivan, Glenn [mailto:GSullivan@xxxxxxx]
> > Sent: 06 November 2002 20:07
> > To: 'ukha_d@xxxxxxx'
> > Subject: RE: [ukha_d] [OT] ms backup tape problem
> > 
> > 
> > Have you tried to go under the tools menu and choose the
> > catalog option?
> > 
> > That should scan the backup set and generate a file catalog for
you.
> > 
> > Glenn Sullivan, MCSE+I  MCDBA
> > David Clark Company Inc.
> > 
> > 
> > -----Original Message-----
> > From: Dr John Tankard [mailto:john@xxxxxxx]
> > Sent: Wednesday, November 06, 2002 3:00 PM
> > To: ukha_d@xxxxxxx
> > Subject: RE: [ukha_d] [OT] ms backup tape problem
> > 
> > 
> > No both servers are w2k
> > 
> > I think the problem is ms backup is not looking at the tape
> > 
> > John
> > 
> > > -----Original Message-----
> > > From: Sullivan, Glenn [mailto:GSullivan@xxxxxxx]
> > > Sent: 06 November 2002 19:50
> > > To: 'ukha_d@xxxxxxx'
> > > Subject: RE: [ukha_d] [OT] ms backup tape problem
> > > 
> > > 
> > > You didn't switch OS's on the server did you?  I found
out a long 
> > > time ago that MSBackup for Win2K will not restore tapes 
> created in 
> > > MSBackup for WinNT4...
> > > 
> > > Glenn Sullivan, MCSE+I  MCDBA
> > > David Clark Company Inc.
> > > 
> > > 
> > > -----Original Message-----
> > > From: Dr John Tankard [mailto:john@xxxxxxx]
> > > Sent: Wednesday, November 06, 2002 2:37 PM
> > > To: ukha_d@xxxxxxx
> > > Subject: [ukha_d] [OT] ms backup tape problem
> > > 
> > > 
> > > I have been fixing a sick server and hit a snag.
> > > 
> > > Got a dead server from a customer, they don't have a 
> receint backup 
> > > and no ups :-o
> > > 
> > > To cut a long story short, I have taken the stuffed disk
> and put it 
> > > into my server use MS backup and dumped it to dat DSS4 tape,
log 
> > > reports a good copy.
> > > 
> > > I have re-installed w2kServer onto the disk, then 
> installed arcserve 
> > > onto the new server then recoverd the system setup, and all
> > > directories. Up to this point all ok. The server 
> re-booted and looks 
> > > almost normal, 1 problem sql server will not start, because
it 
> > > cannot see its data. (and the sql agent cannot copy the data
back 
> > > because sql is not running) so my plan was now to return
> the drive 
> > > to my server use the msbackup to copy back the sql data and
logs.
> > > 
> > > Here is the problem
> > > 
> > > When I go into ms backup select restore, select the tape I
want I 
> > > see a folder with a ? Mark in it x2 click does nothing 
> but flash dlg 
> > > box up so fast I cannot see it, if I try a restore all again
> > > nothing. I am beginning to think there is a problem with
> the backup 
> > > set (the data on the disk might be stuffed anyway but I 
> would like 
> > > to give it a go)
> > > 
> > > Any ideas
> > > 
> > > 1) how to read the ms backup tape
> > > 
> > > 2) use arcserve to restore the data in a form I can copy
> back, and 
> > > then start sql server.
> > > 
> > > 
> > > I do have sql server 2000 sp3 on my server but the 
> customers server 
> > > looks like sp1 to me, I don't want to restore customer
master to 
> > > mine and stuff mine.
> > > 
> > > 
> > > John
> > > 
> > > 
> > http://www.automatedhome.co.uk
> > Post message: ukha_d@xxxxxxx 
> > Subscribe:  ukha_d-subscribe@xxxxxxx 
> > Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
> > List owner:  ukha_d-owner@xxxxxxx
> > 
> > List of UKHA Groups here -
> > http://groups.yahoo.com/group/UKHA_Grouplists/
> > 
> > Your use of
> > Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> > 
> > 
> http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx 
> Subscribe:  ukha_d-subscribe@xxxxxxx 
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
> List owner:  ukha_d-owner@xxxxxxx
> 
> List of UKHA Groups here - 
> http://groups.yahoo.com/group/UKHA_Grouplists/
> 
> Your use of Yahoo! Groups is subject to 
> http://docs.yahoo.com/info/terms/
> 
> 
> 
> http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx 
> Subscribe:  ukha_d-subscribe@xxxxxxx 
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
> List owner:  ukha_d-owner@xxxxxxx
> 
> List of UKHA Groups here - 
> http://groups.yahoo.com/group/UKHA_Grouplists/
> 
> Your use of 
> Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> 
> 
> 
http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here -
http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here -
http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here -
http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/



http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx 
Subscribe:  ukha_d-subscribe@xxxxxxx 
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx 
List owner:  ukha_d-owner@xxxxxxx
List of UKHA Groups here - http://groups.yahoo.com/group/UKHA_Grouplists/

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.