{"id":95,"date":"2011-08-03T13:21:00","date_gmt":"2011-08-03T13:21:00","guid":{"rendered":"\/post\/2011\/08\/03\/Move-Lync-database-to-new-sql-server.aspx"},"modified":"2011-08-03T13:21:00","modified_gmt":"2011-08-03T13:21:00","slug":"move-lync-database-to-new-sql-server","status":"publish","type":"post","link":"https:\/\/www.vatland.no\/index.php\/move-lync-database-to-new-sql-server\/","title":{"rendered":"Move Lync database to new sql server."},"content":{"rendered":"

This is how I’ve done it. First in lab then in production. This is moving enterprise edition databases. For this to work you need one extra temporary sql server and one Lync server in a temporary Lync pool ,along with the new SQL production server.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
1.<\/td>\nExport Lync configuration just in case.
export-csconfiguration -file c:\\lyncconfig.zip<\/strong>
export-cslisconfiguration -file <\/strong>c:\\lynclisconfig.zip<\/strong><\/a><\/span><\/td>\n<\/tr>\n
2.<\/td>\nInstall a new Lync server in a new pool. I.e temppool.corp.local<\/td>\n<\/tr>\n
3.<\/td>\nInstall a new CMS (configuration management store) on temporary sql server.
install-csdatabase -CentralManagementDatabase -sqlserverfqdn tempsql.corp.local<\/strong><\/td>\n<\/tr>\n
4.<\/td>\nEnable topology.
enable-cstopology<\/strong><\/td>\n<\/tr>\n
5.<\/td>\nLogon to new server in new pool and move CMS Lync server.
move-csmanagementserver<\/strong>
Verify that you are moving it to the new server and select.
Get-csmanagementreplicationstatus <\/strong>
Wait for replication.<\/td>\n<\/tr>\n
6.<\/td>\nUninstall old CMS database.
Uninstall-csdatabase -CentralManagementDatabase -sqlserverfqdn OLDSQLSERVERFQDN.corp.local <\/strong><\/td>\n<\/tr>\n
7.<\/td>\nBackup Lync databases. All of them.<\/td>\n<\/tr>\n
8.<\/td>\nIn topologybuilder create a new sql server at the enterprise pool properties and publish topology.<\/td>\n<\/tr>\n
9.<\/td>\nRun Lync server setup deployment wizard.<\/td>\n<\/tr>\n
10.<\/td>\nTurn off all Lync frontend servers.<\/td>\n<\/tr>\n
11.<\/td>\nRestore Databases to the newley created databases. Remember to enable Chaining on the RTC and RTCDYN databases. Enable cross database chaining in the sql server properties. (SQL 2008 R2) In SQL-query : alter-database rtc set db_chaining = on alter-database rtcdyn set db_chaining = on<\/td>\n<\/tr>\n
12.<\/td>\nStart Lync servers.<\/td>\n<\/tr>\n
13.<\/td>\nMover CMS to new SQLserver. step 1 – 6<\/td>\n<\/tr>\n
14.<\/td>\nDelete temppool from topologybilder and publish.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

This is how I’ve done it. First in lab then in production. This is moving enterprise edition databases. For this to work you need one extra temporary sql server and one Lync server in a temporary Lync pool ,along with the new SQL production server. 1. Export Lync configuration just in case.export-csconfiguration -file c:\\lyncconfig.zipexport-cslisconfiguration -file c:\\lynclisconfig.zip … Continue reading Move Lync database to new sql server.<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[6],"tags":[],"class_list":["post-95","post","type-post","status-publish","format-standard","hentry","category-lync"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"jetpack-related-posts":[{"id":170,"url":"https:\/\/www.vatland.no\/index.php\/lync-server-2013automatic-collection-of-configuration-data-failed\/","url_meta":{"origin":95,"position":0},"title":"Lync server 2013:Automatic collection of configuration data failed.","author":"Atle","date":"May 15, 2014","format":false,"excerpt":"Wanted to install a second Central site in my Lync 2013 deployment. Added the site , pool and servers to my Topology Builder. Deployed it and started installing the new server. When installation came to the point where it is supposed to locate CMS and replicate it : \"Automatic collection\u2026","rel":"","context":"In "Lync"","block_context":{"text":"Lync","link":"https:\/\/www.vatland.no\/index.php\/category\/lync\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":526,"url":"https:\/\/www.vatland.no\/index.php\/error-installing-skype-for-business-server-2015\/","url_meta":{"origin":95,"position":1},"title":"Error installing Skype for Business server 2015","author":"Atle","date":"September 3, 2015","format":false,"excerpt":"Tried to install S4B server 2015 in my lab. Tried this from a computer with no internet access, also I did not install any prerequisites. \"Error: Prerequisite installation failed: Prerequisite installation failed: SqlInstanceRtc For more information, check your SQL Server log files. Log files are in the folder C:\\Program Files\\Microsoft\u2026","rel":"","context":"In "Lync"","block_context":{"text":"Lync","link":"https:\/\/www.vatland.no\/index.php\/category\/lync\/"},"img":{"alt_text":"installerror","src":"https:\/\/i0.wp.com\/www.vatland.no\/wp-content\/uploads\/2015\/09\/installerror.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.vatland.no\/wp-content\/uploads\/2015\/09\/installerror.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.vatland.no\/wp-content\/uploads\/2015\/09\/installerror.png?resize=525%2C300 1.5x"},"classes":[]},{"id":67,"url":"https:\/\/www.vatland.no\/index.php\/lync-callerid-black-list-block-list\/","url_meta":{"origin":95,"position":2},"title":"Lync CallerID black list \/ block list","author":"Atle","date":"June 13, 2012","format":false,"excerpt":"After some time using Bing I have manged to do this. Thanks to : http:\/\/ucken.blogspot.no\/2012\/02\/re-routing-incoming-calls-to.html\u00a0 I wanted the caller that is blocked to get a announcment. Step 1. Install Microsot Lync Server 2010\/2013 SDK. Step 2. Create a announcement using new-csannouncement.New-CsAnnouncement -Identity \"Applicationserver:server.contoso.com\" -Name \"NumberBlocked\" -TextToSpeechPrompt \"Sorry, Your call has\u2026","rel":"","context":"In "Lync"","block_context":{"text":"Lync","link":"https:\/\/www.vatland.no\/index.php\/category\/lync\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":45,"url":"https:\/\/www.vatland.no\/index.php\/lync-server-2013-rollup-db-error\/","url_meta":{"origin":95,"position":3},"title":"Lync server 2013 Rollup DB error.","author":"Atle","date":"March 4, 2013","format":false,"excerpt":"After installing update rollup for Lync server 2013 I ran the \"Install-csdatabase ......\" and it Failed. The reason\u00a0was that I did not have enough free disk space on the disk. Rezised and reran command. OK. Extended my c:\u00a0drive to 60 GB.","rel":"","context":"In "Lync"","block_context":{"text":"Lync","link":"https:\/\/www.vatland.no\/index.php\/category\/lync\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":559,"url":"https:\/\/www.vatland.no\/index.php\/lync-server-security-fix-kb3080353-causing-problems\/","url_meta":{"origin":95,"position":4},"title":"Lync server security fix KB3080353 causing problems.","author":"Atle","date":"September 22, 2015","format":false,"excerpt":"(UPDATED) After we installed the Latest Lync server 2013 security fix (Security Update for Lync Server 2013 Web Components Server KB3080353) we have had severeal issues where users where unable to sign in to\u00a0 Lync. This was the server complaining about the client certificate , normally it is the client\u2026","rel":"","context":"In "Lync"","block_context":{"text":"Lync","link":"https:\/\/www.vatland.no\/index.php\/category\/lync\/"},"img":{"alt_text":"LyncCertError","src":"https:\/\/i0.wp.com\/www.vatland.no\/wp-content\/uploads\/2015\/09\/LyncCertError.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":71,"url":"https:\/\/www.vatland.no\/index.php\/lync-phone-calls-failes-and-log-reportssniff-that-lync-server-cancel-it\/","url_meta":{"origin":95,"position":5},"title":"Lync phone calls failes, and log reports\/sniff that Lync server cancel it.","author":"Atle","date":"May 16, 2012","format":false,"excerpt":"When calling some foreign numers Lync server\u00a0CANCEL the call when it is in progress. Network sniff shows that the call is terminates after 10 sec. \u00a0 This is a default value of the Lync Routing engine. The value is located in \"c:\\program files\\Microsoft Lync Server 2010\\Server\\Core\\OutboundRouting.exe.config\" SOLUTION:Replace value \"FailOverTimeout\" value\u2026","rel":"","context":"In "Lync"","block_context":{"text":"Lync","link":"https:\/\/www.vatland.no\/index.php\/category\/lync\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":0,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vatland.no\/index.php\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}