Blackberry PRD-10459-003 Administration Guide - Page 115

Administration Guide Configuring the BlackBerry Configuration Database for one-way transactional replication in an environment that includes Microsoft SQL Server 2005 or 2008 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. 2. Right-click the server. Click Properties. 3. Click Advanced. 4. In the Miscellaneous section, set the Max Text Replication Size to the maximum, 2147483647. 5. Click OK. Prepare the database server that hosts the replicated BlackBerry Configuration Database and configure the subscription 1. In the Microsoft® SQL Server® Management Studio, in the left pane, connect to the database server that hosts the replicated BlackBerry® Configuration Database. 2. Navigate to the database server that hosts the replicated BlackBerry Configuration Database. 3. Click Replication. 4. Right-click Local Subscriptions. Click New Subscription. 5. In the list of publishers, select the name of the database server that hosts the BlackBerry Configuration Database. 6. In the list of databases and publications, select the publication for the BlackBerry Configuration Database. Click Next. 7. Select Run each agent at its Subscriber (pull subscriptions). Click Next. 8. In the Subscriber column, select the database server that hosts the replicated BlackBerry Configuration Database. 9. In the Subscription Database drop-down list, select the replicated BlackBerry Configuration Database. Click Next. 10. Change the distribution agent security so that you can access the Snapshot Agent using a Windows® account with administrative permissions on the domain. 11. Select By impersonating the process account. 12. Click OK. Click Next. 13. In the Agent Schedule drop-down list, select Run continuously. Click Next. 14. In the Subscription properties, clear Initialize. Click Next. 15. Select Create the Subscriptions. Click Next. 16. Click Finish. 113