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)
The information in this article applies to:
- Microsoft SQL Server 2000 Enterprise Edition
- Microsoft SQL Server 2000 Developer Edition
- Microsoft SQL Server 2000 Desktop Engine (MSDE)
- Microsoft SQL Server 2000 Personal Edition
- Microsoft SQL Server 2000 Standard Edition
Bug #: 473802 (SQL Server 8.0)
SYMPTOMSIn 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'
RESOLUTIONTo 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.STATUSMicrosoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.REFERENCESFor more information about how to create a removable
database, visit the following Microsoft Web site: For
more information about how to use the sp_create_removable system stored procedure, visit the following Microsoft Web
site:
Modification Type: | Major | Last Reviewed: | 4/27/2005 |
---|
Keywords: | kbprb KB896556 kbAudITPRO |
---|
|