This chapter describes general issues and principles for administering a running SQL Remote installation.
For system-specific details, see Administering SQL Remote.
Administration of a deployed and running SQL Remote setup is carried out at a consolidated database.
Permissions As a SQL Remote installation includes many different physical databases, a consistent scheme for users having permissions on remote and consolidated databases is necessary. A section of this chapter describes the considerations you need to make when assigning users permissions.
Configuring message systems Each message system that is used in a SQL Remote installation has control parameters and other settings that must be set up. These settings are discussed in this chapter.
The Message Agent The Message Agent is responsible for sending and receiving messages.
Message tracking Administering a SQL Remote installation means managing large numbers of messages being handed back and forth among many databases. A section on the SQL Remote message tracking system is included to help you understand what the messages contain, when they are sent, how they are applied, and so on.
Log management SQL Remote obtains the data to send from the transaction log. Consequently, proper management of the transaction log, and proper backup procedures, are essential for a smoothly running SQL Remote installation. While many details depend on the server you are running, the generic issues are discussed in this chapter.
Passthrough mode This is a method for directly intervening at a remote site from a consolidated database. This method is discussed in this chapter.