RE: [OT] ms backup tape problem

["Christian Cundall \(Groups\)" <groups@xxxxxxx>]

Arcserve and Backup Exec like to install their own tape device drivers
and
take complete control of the tape device - you problem may lie there.

Christian

-----Original Message-----
From: Dr John Tankard [mailto:john@xxxxxxx]
Sent: 06 November 2002 20:36
To: ukha_d@xxxxxxx
Subject: RE: [ukha_d] [OT] ms backup tape problem



> 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 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.