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:
Additionally, the following appears in the SQL Server error log:
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