SYMPTOMS
SQL Server 7.0 does not support tape backup when running on the Windows 95 and Windows 98 operating systems.
You can create the tape dump device on computers running Windows 95 or Windows 98 by using a command similar to the following:
EXEC sp_addumpdevice 'tape', 'tapedump1', '\\.\tape0'
However, when you attempt to perform a backup to that device by using the following statement:
backup database pubs to tapedump1
you receive the following error message:
Server: Msg 3201, Level 16, State 5, Line 1
Cannot open backup device 'tapedump1'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
Backup or restore operation terminating abnormally.
Additionally, the following appears in the SQL Server error log:
BackupTapeFile::OpenMedia: Backup device '\\.\tape0' failed to open. Operating system error = 2(The system cannot find the file specified.).