Wednesday, March 21, 2012

Database shows in read only mode ?

Database shows in read only mode when I did try to restore my database.But How to can I convert it to online mode?

pls help

Hi,

You can leave a restored database in one of the following states:

Leave the database ready to use by rolling back the uncommitted transactions. Additional transaction logs cannot be restored. (RESTORE WITH RECOVERY) Leave the database non-operational, and do not roll back the uncommitted transactions. Additional transaction logs can be restored. (RESTORE WITH NORECOVERY) Leave the database in read-only mode. Undo uncommitted transactions, but save the undo actions in a standby file so that recovery effects can be reverted. (RESTORE WITH STANDBY)

No comments:

Post a Comment