SQL 6.5 Restore
-
We're in the middle of DR testing and trying to restore the databases on an SQL 6.5 server from an AIT50 tape. When we go to the restore section and add the AIT tape drive device from which to restore, we are required to enter a location for the device-default is \\.\TAPE0 but on checking the drive's properties we found its location to be TAPE1, so we entered the location as \\.\TAPE1. SQL can then see the device (the lights on the drive flash) but won't display any of the information on the tape. A backup was also made to hard disk, but there are no such problems restoring from that.
Note-the backup is from an NT4 server, and we are attempting to restore it to a 2000 server.
Cheers
Corkie
-
Did you validate the backups visualy on the other machine?
And did you write the backup to the tape from 6.5 backup utility or to the hard drive and then the Widnows NT 4 utility. If from in 6.5 then you can only read tape from in SQL 6.5. If was from NT4 then I am not sure that 2000 and NT4 backups are compatible, but I don't recall there being a change that would make them so.
-
Sorry i should have said that we are attempting to restore to a different machine altogether, since the disaster for which we are trying to prepare would result in the actual physical destruction of the original server. Therefore we would be unable to restore from the hard drive and can only do so from a tape.
The machine onto which we are trying to recover is 2000, whereas the original is NT4. The NT4 machine uses SQL 6.5, so we have installed SQL 6.5 on the new 2000 machine and are trying to restore from a tape on which a backup from the NT4 machine was made. So both machines are of the same environment, apart from the differing OS.
-
Ok, let me backup. DId you validate your tape on the NT4 machine to make sure thedata is there (not impossible to have a bad tape)?
If not please verify that you can see the backup on the NT4 machine that is on the tape first. (Don't restore just validate)
Next did the backup to the tape occurr thru the BACKUP DATABASE TSQL or the GUI process in EM from with SQL 6.5 or did you write to the hard drive and use the NT4 Backup utility to write the tape?
If from 6.5 to tape then are you check the validaty of the tape in SQL 6.5 interfaces or from the Windows 2000 backup utility?
If you are using the 2k utility it will not see the SQL 6.5 made backups.
Also, have you tried to validate the Tape drive is working properly on the W2k machine by mackign a test backup and restore of a text file thru the Windows 2K backup utility? Could be a driver issue.
-
It seems there's been a bit of confusion at my end-i'm on here on behalf of my boss who told me before, that the original machine is NT4. I have just learned that it is in fact 2000. Apologies for the false information, but thanks all the same for trying to sort it!
We checked the driver and it's fine.
The backup was made to the tape using the SQL 6.5 GUI, not the windows backup utility.
The backup went ok so I just assumed the tape would be fine, but how do i check the validity of the tape from SQL to make sure it's ok?
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply