Alter database from Read-Only to Regular mode? A warm-standby database is read-only (Error 5063)
0
votes
1
answer
2638
views
I am trying to change the mode of database from "Standby / Read-Only" to "Normal" mode so that I could use mdf file to attach to other SQL Server.
One instruction that I got was go to Properties --> Options --> State --> change the Database Read-Only from True to False.
Then I got this error message:
**A warm-standby database is read-only.**
Why do I get this error message and what should I do to change the mode?


Asked by Java
(253 rep)
Mar 18, 2023, 12:44 AM
Last activity: Mar 18, 2023, 10:07 PM
Last activity: Mar 18, 2023, 10:07 PM