3.
Right-click
Local Publications
. Click
New Publication
.
4.
If the
Welcome
dialog box appears, click
Next
.
5.
If this is the first time that you are configuring a publication on the database server, perform the following actions:
• Select
<database_server>
will act as its own Distributor
. Click
Next
.
• In the
Snapshot folder
field, type the network location of the snapshot folder. Click
Next
.
6.
In the list of databases, select the BlackBerry Configuration Database name. Click
Next
.
7.
Click
Transactional publication
. Click
Next
.
8.
In the
Objects to publish
list, select
Tables, Stored Procedures, Views, and User Defined Functions
.
9.
If you installed the BlackBerry database notification system on the computer, expand
Tables
and clear the
ServiceConfig
table and the
ServiceTable
table. Click
Next
.
10. If the
Article Issues
dialog box appears, click
Next
.
11. If the
Filter Table Rows
dialog box appears, click
Next
.
12. Select
Schedule the Snapshot Agent to run at the following times
.
13. Accept or change the default schedule. Click
Next
.
14. On the
Snapshot Agent Security
page, click
Security Settings
.
15. Select
Run under the following Windows account
.
16. Type the user name and password of a domain account that has local administrative permissions.
17. Select
By impersonating the process account
.
18. Click
OK
. Click
Next
.
19. Select
Create the publication
. Click
Next
.
20. In the
Publication name
field, type a name for the publication.
21. Click
Finish
.
After you finish:
Verify that you can access the shared snapshot folder from both database servers.
Increase the maximum data size for transactional
replication
When you set up transactional replication, you must increase the default value for the maximum number of bytes of data
that the BlackBerry Enterprise Servercan write to a replicated database column in one transaction.
1.
In the Microsoft SQL Server Management Studio, connect to the database server that hosts the BlackBerry
Configuration Database.
Administration Guide
Configuring BlackBerry Configuration Database high availability
132