BACKUP TAPE AND RESTORE

[Paulvtis]

I have raised this question before but seems there was no answer yet, I am just wondering given the scenario wherein I have 2 servers namely S1 and S2.

Then, I usually backup SQL data to disk and disk to tape using built in win2k backup. I am doing this in S1.

If in case S1, let us say destroyed, stolen or whatever how can I restore the data in the tape to S2.

I tried it but S2 can't recognize the tape media since the contents of the tape was from another server, S1.

How is this? tnx

 

[sbutcher]

Are the tape drives the exact same model? If not and you are using hardware compression, they may not be able to read the others tapes.

 

[Paulvtis]

they are the same. even the servers are the same. where can i see regarding if the hardware compression is enabled or not?

if this is the case then what will be the purpose of my tape backup considering one of its purpose is for disaster recovery. Some told me there is a way but they cant seem to find the way.

tnx

 

[technome]

In the meantime until you get the backup working...
Why not copy the backed up the SQL data base to S2 every day via xcopy and the task scheduler; or create an SQL maintenance plan to backup the data base to S2.Much faster then a recovery from tape.

 

[Paulvtis]

I have this already but my concern is i want to be able to restore the tape to an offsite server.

Why is it like that wherein i can't restore the tape in another server?

tnx