Blackberry SWD-20120924140022907 Increase the maximum data size for transactional replication

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