Microsoft KB Archive/896556

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

Article ID: 896556

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * Microsoft SQL Server 2000 Personal Edition
 * Microsoft SQL Server 2000 Standard Edition

-



Bug #: 473802 (SQL Server 8.0)



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: &quot;logtrunc.cpp&quot;: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: <&quot;logtrunc.cpp&quot;>, 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'



RESOLUTION
To resolve this problem, create a removable media database. To do this, use the sp_create_removable system stored procedure instead of using SQL Server Enterprise Manager or using the CREATE DATABASE statement.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

