RE: [OT] ms backup tape problem

["Sullivan, Glenn" <GSullivan@xxxxxxx>]

Same service pack level as when the backup was done?

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

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

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 the Yahoo! Terms of Service.