Results 1 to 3 of 3

Thread: differential backup and restore...

  1. 11-25-2003, 04:47 PM #1
    DLu
    DLu is offline Registered User
    Join Date
    Mar 2003
    Posts
    383

    differential backup and restore...

    Does anyone know how to restore a full backup and restore a differential backup from the sql enterprise interface?

    I could do it from the isql/w, but also need to find a way to let operator to do it from the interface. I don't find in the all task-->restore database with any "with norecovery" option available which is a must in the following restore the differential backup.
    thanks
    -D
    Reply With Quote Reply With Quote
  2. 11-25-2003, 05:06 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    In restore database -> options tab, choose proper recovery completion state. Default is leave database oprational, that's same as with recovery.
    Reply With Quote Reply With Quote
  3. 11-25-2003, 05:26 PM #3
    DLu
    DLu is offline Registered User
    Join Date
    Mar 2003
    Posts
    383
    Mr. RMIAO:
    It works. Thanks for the tip.
    -D
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules