Home | Knowledge Base Articles | Error Message Attaching the MDF and LDF files

Thank you for your feedback.

Was this useful?

Yes No

Error Message Attaching the MDF and LDF files

Article ID

ias-10497

Article Name

Error Message Attaching the MDF and LDF files

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
    E mail 64 | Error Message Attaching the MDF and LDF files twitter | Error Message Attaching the MDF and LDF files

    • 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.

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

    © IRIS Software Group Ltd 2024