How to add or edit a destination server (Enterprise Manager)

How to Install SQL Server 2000

How To

How to add or edit a destination server (Enterprise Manager)

To add or edit a destination server

  1. Expand a server group, and then expand the primary server.

  2. Expand Management, and then click Database Maintenance Plans.

  3. In the details pane, right-click the database maintenance plan to edit, and then click Properties.

  4. Click the Log Shipping tab, and then click Add or Edit.

  5. In the Directory box, type or select the directory in which to store the transaction logs.

  6. Do one of the following:
    • Click Create New Database to create a new database on the destination server. If you create a new database, you must specify the database name, along with the file directories for the data and logs.

    • Click Use Existing Database if the database already exists on the destination server.