Microsoft KB Archive/931640

= Error message when you try to upgrade a SQL Server 2000 database to a SQL Server 2005 database: &quot;Database ' ' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery.

This issue may occur if the following conditions are true:
 * You upgrade the SQL Server 2000 database by restoring the database backup or by attaching the database file.
 * Before the upgrade, the database has one of the following configurations:
 * The state of the database is marked as read-only.
 * One of the file groups in the database is marked as read-only.



CAUSE
This issue occurs because the database is marked as read-only or has files that are marked as read-only. To perform an upgrade of a SQL Server 2000 database, all file groups in the database must be in read/write mode.



RESOLUTION
To resolve this issue, configure the SQL Server 2000 database and all file groups in the database to be in read/write mode. For more information, see the &quot;ALTER DATABASE&quot; topic in SQL Server 2000 Books Online.



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

Keywords: kbtshoot kbprb kbexpertiseadvanced kbsql2005engine KB931640

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.