Microsoft KB Archive/205557

= PRB: SQL Server Tape Backup is Unsupported on Windows 95/98 Computers =

Article ID: 205557

Article Last Modified on 2/12/2007

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft Windows 98 Standard Edition
 * Microsoft Windows 95

-



This article was previously published under Q205557



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.).



WORKAROUND
For SQL Server on computers running Windows 95 or Windows 98, perform all backups to disk. You can then use Windows 95 or Windows 98 backup to transfer the backup files to tape.



MORE INFORMATION
For additional information about tapes, backups, and the Windows 95 operating system, please see the following articles in the Microsoft Knowledge Base:

133153 Microsoft Backup for Windows 95 Questions and Answers

130946 Troubleshooting Windows 95 Backup

124730 Tape Backup Units Supported in Windows 95

Additional query words: back up 9x 9 win win95 win98 win9x win9 errorlog

Keywords: kbprb KB205557

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.