Results 1 to 3 of 3

Thread: Possible to restore from remote drive

  1. #1
    Guest

    Possible to restore from remote drive

    Our production database is located on one server, and our test database resides on another. Often, we need to restore the production dump to the test database. But the Restore Device from Server window doesn`t seem to allow references to dump files on a different server. I`ve tried using the Add Backup Disk File window to point to the remote location; but it doesn`t seem to save the reference when I close the window.

    I`m sure there`s a way to handle this without copying the dump file from one server to the other.

    This would seem to be a common scenario. Thanks for any suggestions that others have found useful.

  2. #2
    Alex Guest

    Possible to restore from remote drive (reply)

    Hi
    You have a possibility to use dump devices on remote host.
    This situation described in BooksOnlineAdminCompanionPart3Ch5ManagingDumpDevic esAboutDumpDevices

    Bye
    Alex

    On 8/26/98 6:58:35 AM, wrote:
    > Our production database is located on one server, and our test database
    > resides on another. Often, we need to restore the production dump to the
    > test database. But the Restore Device from Server window doesn`t seem to
    > allow references to dump files on a different server. I`ve tried using the
    > Add Backup Disk File window to point to the remote location; but it doesn`t
    > seem to save the reference when I close the window.

    I`m sure there`s a
    > way to handle this without copying the dump file from one server to the
    > other.

    This would seem to be a common scenario. Thanks for any
    > suggestions that others have found useful.

  3. #3
    Guest

    Possible to restore from remote drive (reply)

    MSSQL Server service should be started with domain administrator`s
    account. Then you`ll be able to create remote backup devices.

    VK.

Posting Permissions

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