Results 1 to 15 of 17

Thread: restor from back up error

Threaded View

  1. #1
    Join Date
    Jul 2003
    Posts
    421

    restor from back up error

    I usually use the following statement to restore a database and it work find. but now I got error. can anyone tell me why??
    use master
    go
    RESTORE DATABASE sequences
    FROM disk='H:\backup\sequences(Jun16).bak'
    WITH REPLACE,
    NORECOVERY
    go
    error

    Server: Msg 4306, Level 16, State 1, Line 1
    The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.
    Server: Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.
    ________
    Ford galaxie specifications
    Last edited by sql; 03-06-2011 at 01:39 AM.

Posting Permissions

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