Post reply

What is the use of NORECOVERY command at the time of Restoration

  • November 24, 2004 at 10:36 pm

    #84273

    Dear All

    I have a Question that what is the use of NORECOVERY command at the time of restoration i am a little bit confused, as i am new to this Job of DBA support Engineer.

    Any help would be greatly appreciated.

    Regds

    Dharmendra Mudaliar

    Thanks & Regards
    Dharmendra S Mudaliar
    ( OEM India RSA )
    Hello - +91 40 66934555 x 34555
    Mobile - 9885408049 | IM - v-dharmu@microsoft.com

  • November 27, 2004 at 9:13 am

    #531650

    The NORECOVERY option of the RESTORE statement is usefull if you want to restore additional transaction log backups, after the current restore. You must specify the RECOVERY option (which is the default if you don't specify NORECOVERY or STANDBY) only for the last restore operation.

    Razvan

  • November 28, 2004 at 2:31 am

    #531652

    Dear Razvan

    Thanx for your kind reply. This helped me out a lot. Once a again Thanx for it.

    Dharmendra

    Thanks & Regards
    Dharmendra S Mudaliar
    ( OEM India RSA )
    Hello - +91 40 66934555 x 34555
    Mobile - 9885408049 | IM - v-dharmu@microsoft.com

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

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