Article ID: 931640 - View products that this article applies to.
When you try to upgrade a Microsoft SQL Server 2000 database to a SQL Server 2005 database, you may receive the following error message:
Msg 3415, Level 16, State 3, Line 1
Database 'DatabaseName' 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:
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.
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 "ALTER DATABASE" topic in SQL Server 2000 Books Online.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 931640 - Last Review: November 20, 2007 - Revision: 1.3