Post reply

restore

  • August 12, 2009 at 9:53 am

    #135199

    what is the difference between stanby,recovery,norecovery options when doing restore.

  • August 12, 2009 at 9:55 am

    #1038109

    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?

  • August 12, 2009 at 9:56 am

    #1038111

    Please refer to SQL Server BOL

    or

    http://msdn.microsoft.com/en-us/library/ms186858(SQL.90).aspx

  • June 24, 2013 at 5:51 am

    #1626752

    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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply