How can i switch the database from standby to read only AND Read only to Standby/Readonly mode?
Standby to read only I reckon is two steps:
RESTORE DATABASE MyDatabaseName WITH RECOVERY
and then set it to Read Only, probably like this
ALTER DATABASE MyDatabaseName SET READ_ONLY WITH ROLLBACK IMMEDIATE
but probably a window-of-opportunity between those two commands?
Read Only to Standby - can't be done (AFAIK). Restore from backup again, in Standby mode.
Thank you Kristen !
Standby is already read-only...I think what you are wanting to do is put the database into read-only (standby) and then back to recovering (so you can apply logs).
If the database is restored using STANDBY then can;t you just do more log restores (also in STANDBY)?
Its a while since I've done it, but that's my recollection. I don't remember having to take the DB out of Standby, and then back into Standby to do more restores (and have opportunity to Query the DB too)