I changed the database (foo) mode from "Standby / Read-Only" to Active by using the following statement:
restore database foo with recovery
After that, I changed the mode back to Active by using the following statement:
ALTER DATABASE foo SET READ_WRITE
Then, I changed back to "Read-Only" by using user interface here:
Properties --> Options --> State --> Database Read-Only --> changed to 'True':
Now, I am trying to go back to the original state "Standby / Read-Only" mode (original).
How do I go about doing that?