Difference between 3 types of Restoring modes.


S.No
With Recovery
With Norecovery
Standby\Readonly
1
Leave the database in online mode.
Leave the database in restoring mode.
Leave the database in
 readonly mode.
2
No further restore is possible.
Further restore is possible.
Further restore is possible.
3
User can able to access
Users can’t.
Users can able to read the
 databases.
4
Rollback the uncommitted transactions
Does not rollback the uncommitted transactions
It undoes uncommitted transactions
, but saves the undo actions in a
 standby file so that recovery effects
 can be reverted.


Comments

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)