How to change from "Read-Only" mode to "Standby / Read-Only" mode?

Question

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?

Read here for instructions and explanations: mssqltips.com/sqlservertip/3574/… — White Owl, Mar 21 at 19:34
@WhiteOwl I read the page but where is command to change "to Standby .."? — Java, Mar 21 at 20:26

David Browne - Microsoft · Accepted Answer · 2023-03-21 21:44:04Z

4

You can go from Standby back to Restoring, but after recovery you can't go back to Restoring without restoring the backups again with norecovery.

answered Mar 21 at 21:36

44.3k3 gold badges45 silver badges94 bronze badges

Add a comment |

1 Answer 1