You receive a "Server: Msg 3624, Level 20, State 1, Line 1" error message when you try to back up a database that is stored on read-only media in SQL Server 2000 (896556)

SYMPTOMS

In Microsoft SQL Server 2000, when you try to back up a database that is stored on read-only media such as a read-only CD, you receive the following error message:

Server: Msg 3624, Level 20, State 1, Line 1

Location: "logtrunc.cpp":337
Expression: stLSN != NullLSN
SPID: 57
Process ID: 684

Additionally, you receive an assertion error message in the SQL Server 2000 error log that is similar to the following:

* -------------------------------------------------------------------------------
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E) (CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 0085CA56 Module(sqlservr+0045CA56) (LogTruncMgr::DisableTruncation+000000ED)
* 008200FF Module(sqlservr+004200FF) (BackupManager::SyncWithLog+00000060)
* 0089B5AE Module(sqlservr+0049B5AE) (BackupEntry::BackupDatabase+000003A2)
* 00602FC2 Module(sqlservr+00202FC2) (CStmtDumpDb::XretExecute+0000004F)
* 0041B442 Module(sqlservr+0001B442) (CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357) * 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 77C3A243 Module(MSVCRT+0002A243) (endthread+000000AF)
* 005185C2 Module(sqlservr+001185C2) (StartUp::OpenDBsAndRecover+0000043A)
* -------------------------------------------------------------------------------
2005-02-11 17:32:45.13 spid57 Stack Signature for the dump is 0x72747B69
2005-02-11 17:32:45.14 spid57 SQL Server Assertion: File: <"logtrunc.cpp">, line=337
Failed Assertion = 'stLSN != NullLSN'.
2005-02-11 17:32:45.14 spid57 Error: 3624, Severity: 20, State: 1.
2005-02-11 17:32:45.14 backup BACKUP failed to complete the command backup database ReadOnly to disk='C:\ReadOnly.bak'

REFERENCES

For more information about how to create a removable database, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_92hx.asp

For more information about how to use the sp_create_removable system stored procedure, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_2e79.asp

You receive a "Server: Msg 3624, Level 20, State 1, Line 1" error message when you try to back up a database that is stored on read-only media in SQL Server 2000 (896556)

SYMPTOMS

RESOLUTION

STATUS

REFERENCES