Restoring databases in read-only mode in EM

Question

Restoring databases in read-only mode in EM

Dirk Norman

SSC Veteran

Points: 254
More actions
June 12, 2006 at 7:52 am

#112510

Does anyone know if there is an enterprise manager version of the RESTORE DATABASE WITH Recovery? I am playing with restoring transaction logs and keeping the database as read-only while doing so. When you're all done with the restores, as long as you select the read-only option in restore state, the database is still set as read-only. The only way I have been able to solve this is to use the "RESTORE DATABASE WITH Recovery" command in query analyzer and I would like to know if there's a way to accomplish the same thing through EM. I know you can on the last TLog restore select the leave database operational completion state option, but that's not the solution I'm looking for.
Thanks

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

I'm not clear about what you want. Do you want the database to be in read-only mode after restoring with Enterprise Manager?

Greg

Dirk Norman SSC Veteran Points: 254 More actions · Answer 2

After the full restore yes. What I'm looking for is a way to get a database that is in read-only mode into "normal" mode through enterprise manager.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 3

In Enterprise Manager, right-click on the database, select properties, and select the options tab. Under Access, there is a check box for Read-only. Uncheck that, and the database should be taken out of Read-only mode.

Greg

Dirk Norman SSC Veteran Points: 254 More actions · Answer 4

If a database has been restored in read-only mode you can't uncheck the read-only checkbox in the properties--it gives you an error stating that the database is in warm-standby.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 5

Ahh yeah, that's right. The only way to leave the database operational after restoring log backups in Enterprise Manager is to the check the first option under Recovery Completion State on the Options tab. You say you don't want to do that. Why not?

Greg

Dirk Norman SSC Veteran Points: 254 More actions · Answer 6

Not so much that I don't WANT to, but I'm curious if a database is stuck as read-only after a restore (forgot to select the first option) if there's a way to get it back to normal in EM.

Greg Charles SSC-Forever Points: 45403 More actions · Answer 7

None that I know of. When I was trying to recreate your situation on my test instance, I ended up having to do RESTORE WITH RECOVERY in Query Analyzer just like you did.

Greg