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.

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.

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

VK.