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:


Then, I changed back to "Read-Only" by using user interface here:

Properties --> Options --> State --> Database Read-Only --> changed to 'True':

enter image description here

Now, I am trying to go back to the original state "Standby / Read-Only" mode (original).

How do I go about doing that?

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

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.