在Windows 95/98下您也可以執行如" EXEC sp_addumpdevice 'tape', 'tapedump1', '//./tape0'"的指令,但是當您執行"backup database to tapedump1"時會出現如下的信息: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也會出現如下信息: BackupTapeFile::OpenMedia: Backup device '//./tape0' failed to open. Operating system error = 2(The system cannot find the file specified.).
將SQL Server 7.0數據庫備份到網絡上時出現如下信息 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出現 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.). 如何解決?
這是由于權限不夠造成的。 請確定SQL Server Service的帳號為域用戶(Domain User),并且在網絡上寫權限。