|
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.
|
Tuesday, May 29, 2012
Difference between 3 types of Restoring modes.
Subscribe to:
Post Comments (Atom)
-
Post scripts to implement after successful SQl Server installation in a new server: 1. Listing the advanced configuration options and ...
-
An error occurred while starting mirroring. Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo) The remote copy of dat... -
When i trying to load data from MS access (MDB) to SQL ,i am getting the below error. Error: 0xC0209303 at Package, Connection mana...
No comments:
Post a Comment