Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unanswered: Create new database from backup file?

    Hi all,
    I have a ploblem...
    i have ful backup file, diffrential backup file, transaction log backup file.
    i want to create a new database form backup file.
    i do it follow :
    Using Enterprise manager
    1. Rrestore database from full backup file. it is ok.
    2. affter that i restore different database differential backup file. it does not work, the error is :' Theproceding operationdid not specify WITH NORECOVERY or WITH STANDBY. Resatr the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step. RESTORE DATABASE is terminating abnormally'
    please show me,
    nest regard.

  2. #2
    Join Date
    Oct 2001
    Naples, FL
    If you will be applying a differential backup or a log backup you need to restore the full backup in a recoverable mode. See BOL for syntax

    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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