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?Specify WITH NORECOVERY, and then restore the transaction log. After that, it is just
restore database (name) with recovery|||But I want to do this job from Enterprise manager. I didn't find the check option for the [with recovery].
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment