在Windows 95/98下您也可以執(zhí)行如" EXEC sp_addumpdevice 'tape', 'tapedump1', '//./tape0'"的指令，但是當(dāng)您執(zhí)行"backup database to tapedump1"時(shí)會(huì)出現(xiàn)如下的信息：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.
并且在SQL Server 7.0 errorlog也會(huì)出現(xiàn)如下信息： BackupTapeFile::OpenMedia: Backup device '//./tape0' failed to open. Operating system error = 2(The system cannot find the file specified.).
將SQL Server 7.0數(shù)據(jù)庫(kù)備份到網(wǎng)絡(luò)上時(shí)出現(xiàn)如下信息 Server: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'E:/pubs.dat'. 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. 并且在Error log出現(xiàn) 1998-12-29 11:58:21.62 kernel BackupDiskFile::CreateMedia: Backup device'E:/pubs.dat' failed to create. Operating system error = 5(access is denied.). 如何解決？
這是由于權(quán)限不夠造成的。 請(qǐng)確定SQL Server Service的帳號(hào)為域用戶（Domain User），并且在網(wǎng)絡(luò)上寫(xiě)權(quán)限。
是否可以將SQL Server 7.0數(shù)據(jù)庫(kù)備份到壓縮卷（ComPRessed Volume）？
