Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005

    Question Unanswered: Restore Database

    Hi Everybody,

    I was restoring the database. I have 2 backup files one is complete backup and another is transaction log back file. First I Resotred the complete backup file it restored fine but while I was restoring the transaction log backup file it showed the following error.

    The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITHSTANDBY for all but the final step.
    RESTORE DATABASE is terminating abnormally.

    Please help me. How to restore the database if we have two backup files?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    Specify WITH NORECOVERY, and then restore the transaction log. After that, it is just

    restore database (name) with recovery

  3. #3
    Join Date
    Jul 2005
    But I want to do this job from Enterprise manager. I didn't find the check option for the [with recovery].

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts