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

    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
    Location
    Naples, FL
    Posts
    273
    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

    HTH
    ---------------
    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
  •