Article ID: 931640 - Last Review: November 20, 2007 - Revision: 1.3

Error message when you try to upgrade a SQL Server 2000 database to a SQL Server 2005 database: "Database '<DatabaseName>' cannot be upgraded because it is read-only or has read-only files"

View products that this article applies to.

System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

Expand all | Collapse all

SYMPTOMS

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:

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.

Back to the top

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.

Back to the top

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 "ALTER DATABASE" topic in SQL Server 2000 Books Online.

Back to the top