Have you wanted to know how you can set up a fully replicated PDM and Manage environment?\u00a0 I am going to walk you through the basics of setting up replication of SOLIDWORKS PDM and Manage.\u00a0 To set up a fully replicated secondary site, the site would require SQL Server, a replicated PDM archive server, and a Manage file server.\u00a0 These components could be on the same server or multiple servers.<\/p>\n
![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/KC201812-1-SiteReplication-300x124.jpg\")
<\/p>\n
SOLIDWORKS PDM Archive and Database Replication<\/strong><\/p>\n Since archive replication in SOLIDWORKS PDM has existed for a very long time and has been thoroughly documented, I won\u2019t go in-depth explaining it.\u00a0 For more details, see the SOLIDWORKS PDM Administration Guide.<\/p>\n Database replication in SOLIDWORKS PDM was introduced with the 2017 version and requires the purchase of Microsoft\u2019s SQL Server Enterprise Edition.\u00a0 Setting up database replication requires setting up a failover cluster in Windows Server and configuring the \u2018AlwaysOn Availability Groups\u2019 (AOAG) in SQL Server.\u00a0 With AOAG, the primary site will handle both read and write operations and the secondary site will be used for read operations.\u00a0 Users or groups will be assigned to access the secondary site through the PDM Administration tool.<\/p>\n The users accessing the secondary site will see a performance improvement with read operations, such as when viewing data on the data card or contains tab.\u00a0 The users will still need access to the primary database for writing to the database, such as during check-in.<\/p>\n The details of setting up the failover cluster and AOAG are an IT function outside the scope of the normal PDM installation.\u00a0 Information on the setup can found on Microsoft\u2019s website and other sites.\u00a0 We do explain the basics of setting this up in Knowledge Base Article S-072960 and an example on how to set up a test environment is explained in S-073461.<\/p>\n SOLIDWORKS Manage File Server and Database Replication<\/strong><\/p>\n To setup replication in Manage, you need to first install the File Server on the server at the secondary site.\u00a0 Database replication in Manage can utilize SQL Server ‘Transactional Replication’ between sites using SQL Server Standard edition but also can be configured to use ‘Always On Availability Groups’ in SQL Server Enterprise.\u00a0 Since PDM requires the use of AOAG, this is the preferred method for Manage.<\/p>\n To set up database replication using ‘Always On Availability Groups’, ensure the failover cluster and an availability group is created and add the Manage database to the availability group.<\/p>\n After the database is configured in SQL Server and the File Server is installed, you will need to enable replication in Manage and create a secondary site.<\/p>\n To enable replication, go to the Administrative Options and under the Advanced section, select the General page.<\/p>\n To create a site, go to the Administrative Options and under the Advanced section, select the Sites page.\u00a0 Create a new site and enter the URL for the file server of the new site.<\/p>\n Select the “Local database replication” tab and choose “Use a LOCAL database to read data (for this site)”.\u00a0 Then enter the information for the replicated database. \u00a0This site will now be assigned to connect to the replicated database.<\/p>\n Any users that log into the secondary site will access the replicated database for read operations but write operations will still be pushed to the primary database.<\/p>\n When users access a document in Manage that does not exist on the File Server that they are connecting to, the file will be downloaded to the secondary File Server.<\/p>\n This should guide you through the steps required to configure PDM and Manage to create a fully replicated multi-site environment.<\/p>\n <\/p>\n Verifying Backups is the Best Backup<\/p>\n By James Falconer<\/span><\/p>\n Most computer users now create backups of their data on a regular basis, which is a great thing that took years of convincing, reiteration, and hard-learned lessons. This is especially important for PDM administrators and users who create and manage incredibly valuable data.<\/p>\n In today’s world, we are constantly reminded of threats to our data. Ranging from ransomware to social engineering, and identity theft, we must now be more vigilant than ever to safeguard our data. These threats in combination with the possibility of failing hardware, data corruption, and simple mistakes, magnify the importance that backups are of utmost importance.<\/p>\n One component of a fully rounded backup strategy that is all too often missing is backup testing. This is where you restore your backup (Database and Archives) onto a sandbox machine and perform tests on the data. This would include reviewing logs to see if any errors were seen during restore, as well as running checks on the database. Batches of files and a few large assemblies should be run through regular work procedures (Checking out, checking in, push through workflow, etc). We also recommend that verification is performed at least once a quarter.<\/p>\n A fully documented verification testing document is beyond the scope of this article, but the basics should be performed by anyone who values their data. Based on the size and complexity of the vault, testing will differ based on many factors. But there are universal benefits that would be enjoyed by everyone who verifies their backups which include;<\/p>\n * Recovery becomes a regular and fully practiced procedure<\/p>\n * Recovery variables, such as how much time it takes, will become a known entity<\/p>\n * Recovery improves as this becomes a regularly tested component<\/p>\n * Recovery testing may help minimize problems if caught early enough (such as data corruption)<\/p>\n Verifying backups is a necessary step that should be a standard procedure for anyone managing and administering data, especially with SOLIDWORKS PDM. Once the verification procedure is created, scheduled, and run, anyone working with PDM should feel much more confident that their backups are there to do exactly what they were intended to do; Be a backup in case of problems.<\/p>\n <\/p>\n SOLIDWORKS WORLD 2019 right around the corner<\/p>\n By Nicole Phillips<\/span><\/p>\n One great event you don’t want to miss is SOLIDWORKS WORLD!\u00a0 For 2019 we’re back in Dallas, Texas at the Kay Bailey Hutchison Convention Center February 10-13, 2019.\u00a0 There is still time to register<\/a> and attend this great event.\u00a0 Expand your knowledge with some of our available technical sessions.\u00a0 Click this link<\/a> to view the Agenda and events available to you.<\/p>\n <\/p>\n Noteworthy Solutions from the SOLIDWORKS Knowledge Base<\/span><\/p>\n <\/p>\n That\u2019s it for this month. Thanks for reading this edition of SOLIDWORKS Support News. If you need additional help with these issues or any others, please contact your SOLIDWORKS Value Added Reseller.<\/p>\n <\/p>\n Comments and suggestions are always welcome. You can enter them below.<\/p>\n","protected":false},"excerpt":{"rendered":" Hello to all, Welcome to the new edition of the SOLIDWORKS Support Monthly News!\u00a0 This monthly news blog is co-authored by members of the SOLIDWORKS Technical Support teams worldwide. Creating a fully replicated multi-site environment of SOLIDWORKS PDM Professional<\/p>\n... Continued<\/a>","protected":false},"author":458,"featured_media":6787,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[497,32,34,35,1],"tags":[2527,2528,2305,1006],"class_list":["post-22414","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-solidworks-support-monthly-news","category-solidworks-world","category-support","category-tips-tricks","category-uncategorized","tag-backup-and-restore","tag-replication","tag-solidworks-manage","tag-solidworks-pdm"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/22414","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/users\/458"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/comments?post=22414"}],"version-history":[{"count":16,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/22414\/revisions"}],"predecessor-version":[{"id":22476,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/22414\/revisions\/22476"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/media\/6787"}],"wp:attachment":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/media?parent=22414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/categories?post=22414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/tags?post=22414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/KC201812-2-Administration-300x168.png\")
<\/p>\n![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/KC201812-3-ManageAdmin-300x210.jpg\")
<\/p>\n![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/KC201812-4-ManageAdmin2-300x210.png\")
<\/p>\n![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/KC201812-4-ManageLogin-300x152.png\")
<\/p>\n![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/backup_restore.png\")
<\/p>\n![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/SWW2019-300x74.jpg\")
<\/a><\/p>\n![\"icon](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/Screen-capture3.png\")
Why is the \u2018Enable performance pipeline\u2019 option unavailable?<\/b>
\nFor more information, see Solution Id: S-075336<\/a>.<\/p>\n![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/SOLIDWORKS-Electrical-Icon.png\"){kind=icon}
In SOLIDWORKS\u00ae PCB, can I make a change to all of the symbols in the Schematics library at the same time?<\/b>
\nFor more information, see Solution Id: S-075246<\/a>.<\/p>\n![\"Icon](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/Screen-capture1.png\")
Using SOLIDWORKS\u00ae PDM 2018 SP1-SP4, why is performance slow when refreshing reference trees in the SOLIDWORKS add-in and in reference dialog boxes that display variables in columns?<\/b>
\nTo verify and resolve this issue, follow the steps in Solution Id: S-075446<\/a>.<\/p>\n![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/Screen-capture4.png\")
In a SOLIDWORKS\u00ae Plastics ‘Cool’ analysis, where can I find the Reynolds number for each cooling channel?
\n<\/b>For additional information on where to find the Reynolds number, check out solution Id: S-075219<\/a>.<\/p>\n![\"\"](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/4\/Flow-Simulation-icon.png\"){kind=icon}
How are the ambient conditions at the boundaries of the Computational Domain enforced in an external flow project?<\/b>
\nFor more information, see Solution Id: S-075324<\/a>.<\/p>\n
\n