The SQL database prompts "read-only" solution (SQL error 5120), sql5120

The SQL database prompts "read-only" solution (SQL error 5120), sql5120

1. Description: database server. The disk is full. You need to move a large database file to another disk. After the migration, the "read-only" prompt is displayed when you re-attach the database. ()

2. Assume that the "database is read-only" option is directly set from true to false in "attribute-Option-status ".
But How fucking it is! Error reported

3. SQL error 5120
This error is caused by a File Permission error. Find the database files and log files of the database, add Authenticated Users user permissions to security, and set "full control"

4. Change "database read-only option" to "false" in the database attribute again. The database is normal.

Articles you may be interested in:

• Solution to read-only or failure after attaching a database to SQLServer
• How to set some tables in the SQLServer database to read-only
• MSSQL2005 reports on running the attached database with networkservice permissions (Microsoft SQL Server, error: 5120)
• SQL2008 attach database prompt 5120 error Solution
• SQL2008 attaching database prompt 5120 error Solution
• When attaching a database to SQL Server 2005, an error occurs, indicating that the operating system is incorrect. 5 (Access denied). 5120 Solution
• How to handle the 5120 error message when MSSQL adds a database to reject access?
• How to Create a read-only user in SQL Server 2008 database