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

SQL Server:Steps to Configure Database Mirroring by T-SQL Script.

SSIS2008R2 Error: 0xC0209303 at Package: