Post reply

RestoreinSQL SERVER 2005

  • February 2, 2009 at 4:33 pm

    #196775

    you have begun a restore process using a full backup from the previous night .The tape drive fails with 75 percent of the restore method. You replace the drive.

    which one of the following you do to minimize the time to restore.

    1) start again

    2) restore with recovery

    3)restore with norecovery

    4)restore with standby

    thanks in advance

  • February 2, 2009 at 4:47 pm

    #936802

    1) start again


    * Noel

  • February 2, 2009 at 6:59 pm

    #936859

    Hi Neol

    thanks for the response

    Could you explain

    loka

  • February 3, 2009 at 8:47 am

    #937192

    The database wouldn't be in a position for you to restore any other way other than from scratch

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

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