Error Message Attaching the MDF and LDF files

Article ID

ias-10497

Article Name

Created Date

5th July 2012

Product

Problem

Database [Database_Name] cannot be upgraded because it is read-only or has read-only files When trying to attach a databases on a SQL Server 2008 R2 instance. The database files were copied over the network and located on a drive on a standalone PC. When trying to attach the databases the following error message occurred: Msg 3415, Level 16, State 3, Line 1 Database [database_name] cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. Msg 1813, Level 16, State 2, Line 1 Could not open new database [database_name]. CREATE DATABASE is aborted.

Resolution

IRIS Support recommends that your restore from your last good backup. If a good backup is not available following the steps below may help to resolve the problem.

Check the permissions of the database files and ensured that they are not read-only.

Give full access to “Everyone” on all the database files you want to attach

Once attached successfully remove the full access from the “Everyone” entity and so everything is set back to normal.

Share This Page

Thank you for your feedback.

Was this useful?

Yes No

We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.

Escalate to Support?

First Name *

Last Name *

Company Name *

Email Address *

Phone Number *

IRIS Feedback *

For information on how we manage your data please view our privacy policy

Error Message Attaching the MDF and LDF files

Related Products

IRIS VAT Filer – AiB

IRIS Analytics

IRIS Innervision Lease Accounting

Related Articles