Show TOC

Backing Up and Restoring with Remote ComputersLocate this document in the navigation structure

Use

You can back up data and redo log entries to data carriers on remote computers, check backups on remote computers, or use backups from a remote computer to restore a database.

To do this, you start the database service on the local database computer under the name of an operating system user that exists on both the local database computer and the remote computer and then log on to the remote computer using the same operating user name.

Note that backups to remote computers are prone to errors during transfer. They also take longer than backups to the local database computer.

Figure 1: Backing Up and Restoring Data with Remote Computers
Prerequisites
  • There is an operating system user that exists on both computers.

    Note

    In general, the service of the database runs under a special operating system user.

    More information: Special Operating System Users and Groups

  • This operating system user has the necessary authorizations for the required directories on both computers, and is thus authorized to write and read the backups on the remote computer.

Procedure

Microsoft Windows

  1. On the database computer, open Services management in the Microsoft Management Console.

  2. Stop the service of the database you want to restore or back up.

  3. Open the properties of this service.

  4. On the Log On tab page, enter the operating system user that exists on both computers.

  5. Restart the service of the database.

Unix and Linux

No additional actions are necessary.