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"

Article translations Article translations
Article ID: 931640 - View products that this article applies to.
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.

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 "ALTER DATABASE" 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 "Applies to" section.

Properties

Article ID: 931640 - Last Review: November 20, 2007 - Revision: 1.3
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
Keywords: 
kbsql2005engine kbexpertiseadvanced kbtshoot kbprb KB931640

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com