Search: Advanced search

SDE Replication MSSQL

Article ID: 457

Last updated: 27 Dec, 2019

Revision: 1

Export to PDF

Email to friend

The SDE Replication MSSQL monitoring point checks to verify if a scheduled SDE replication has happened, and whether or not it was successful.

There is not currently a scheduler in the GeoSystems Monitor, so scheduling information needs to be added as parameters to the point check. Presently, the point can check every day of the week at a certain time, or the user can enter single/multiple days of the week and a time (for example, all:22 would run a check every day at 10 P.M. 1,2,4:21 would run a check on Sunday, Monday, and Wednesday at 9 P.M.)

Note that the time entered for the point check should be set after the scheduled replication is to occur by approximately one hour (for example, if replication is set to run at 2100 (9 P.M.), set the point to start checking at 22 (10 P.M.).

The parameters that are unique to the SDE Replication MSSQL include:

Server Name	Server name where SDE database is located
Database	SDE database name
Replication Name	Name of SDE replication
SDE-DBO Schema	SDE or DBO
userID:PW	user ID and user PW with access to the SDE database (Note colon separating User ID:PW) (Database Authentication). If using Windows AD authentication, enter Domain\UserID:PW *Note:* userID and userPW should be entered as encrypted information
Days:Time	Presently, the point can check every day of the week at a certain time, or the user can enter single/multiple days of the week and a time (for example, all:22 would run a check every day at 10 P.M. 1,2,4:21 would run a check on Sunday, Monday, and Wednesday at 9 P.M.)

Prev		Next
SDE Layer		SDE Replication Oracle