restoring from tape to different server

hello all,
I preform regular sql server 2000 backups on our production server (Windows
2000 Server). I now need to restore, the Production DB to the backup server
(Windows 2000 Server) from tape (hp dds-4 data cartridge). The restore db
wizard (database radio button selected) should shows a list of all available
backups, but my backups to tape are not visible. Can someone explain this? I
know tape backups actually exist because I had verify backup selected and I
can see them on the production server.
When I select the "From Device" radio but on the wizard and then select my
tape drive everything is accepted, however everything locks up when I attemp
t
to "View Contents..." Any Ideas about that?
Please advise and remember I am a rookie?
much thanks
AndreAndre
Did you perform your backups direct to tape or did you do them to disk first
then copy to tape? If you did them to disk (the best way for speed and ease
of use), I suggest you copy them back to disk, then do you restore.
I'm afraid I don't know what your problem is if you performed your backups
direct to tape, as I have not done that since the days of version 6.5. Rathe
r
than using EM, have you tried using query analyser, with the restore command
?
HTH
John
"Andre Gibson" wrote:

> hello all,
> I preform regular sql server 2000 backups on our production server (Window
s
> 2000 Server). I now need to restore, the Production DB to the backup serve
r
> (Windows 2000 Server) from tape (hp dds-4 data cartridge). The restore db
> wizard (database radio button selected) should shows a list of all availab
le
> backups, but my backups to tape are not visible. Can someone explain this?
I
> know tape backups actually exist because I had verify backup selected and
I
> can see them on the production server.
> When I select the "From Device" radio but on the wizard and then select my
> tape drive everything is accepted, however everything locks up when I atte
mpt
> to "View Contents..." Any Ideas about that?
> Please advise and remember I am a rookie?
> much thanks
> Andre
>