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

    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
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Specify WITH NORECOVERY, and then restore the transaction log. After that, it is just

    Code:
    restore database (name) with recovery

  3. #3
    Join Date
    Jul 2005
    Posts
    9
    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
  •