Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

restore Expand / Collapse
Author
Message
Posted Wednesday, August 12, 2009 9:53 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:20 AM
Points: 432, Visits: 1,073
what is the difference between stanby,recovery,norecovery options when doing restore.
Post #769455
Posted Wednesday, August 12, 2009 9:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 1,001, Visits: 13,532
recovery bring the database online and allows full database activity.

norecovery leaves the database in a restoring state ready for the next backup file to be applied (nobody can connect in this state)

Standy puts the database in a read only state and is normally seen in this state during a log shipping scenario.

Why do you ask? do you have a specific problem or is just a general knowledge question?
Post #769458
Posted Wednesday, August 12, 2009 9:56 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, December 16, 2013 12:24 PM
Points: 476, Visits: 1,376
Please refer to SQL Server BOL
or
http://msdn.microsoft.com/en-us/library/ms186858(SQL.90).aspx



Post #769460
Posted Monday, June 24, 2013 5:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 1:13 PM
Points: 15, Visits: 59
standby:database is in stand by mode means only read purpose available for selection.generally this state is kept for logshipping.DML commands doesnt work in this mode..
norecovery:the database is looking for additional backups while restore it means u can add additional backups to database online from point of failure.mirroring we keep database in a no recovery(restoring mode).
database becomes non-operational
recovery: database is in online mode,operational mode,not possible to apply furthur backups
Post #1466703
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse