New Persistent Chat server from W2008R2 to Windows2012R2

%3CLINGO-SUB%20id%3D%22lingo-sub-15019%22%20slang%3D%22en-US%22%3ENew%20Persistent%20Chat%20server%20from%20W2008R2%20to%20Windows2012R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-15019%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20customer%20that%20runs%20Persistentchat%20on%20a%20upgraded%20server%20who%20has%20windows2008R2%20with%20Skype%20for%20Business.%20We%20want%20to%20move%20the%20whole%20Persistent%20chat%20into%20a%20windows%202012R2%20(virtual)%20with%20skype%20for%20business%20running.%3CBR%20%2F%3EThe%20customer%20has%20Skype%20for%20business%20Enterprise%20with%20SQL%20server%202012R2%20running%20mirroring%20mode.%20Since%20databases%20are%20located%20on%20the%20SQL01%20server%20in%20the%20mirror%2C%20well%20I%20am%20not%20sure%20about%20how%20to%20build%20the%20new%20server%2C%20export%20the%20database%20and%20put%20it%20back%20on%20the%20%22SQL01%22.%3CBR%20%2F%3ETo%20export%20was%20no%20problem%20but%20I%20can't%20use%20the%20SQL%20again.%3CBR%20%2F%3EMust%20I%20to%20it%20like%20this%3F%3CBR%20%2F%3E1.%20Create%20a%20new%20Persistenchat%20server%20in%20the%20topology%3CBR%20%2F%3E2.%26nbsp%3B%20name%20the%20new%20database%20server%3CBR%20%2F%3E3.%20%26nbsp%3Binstall%20a%20new%20SQL%20server%20import%20the%20PersistentChat%20database%20on%20that%20server%20and%20then%20publish%20the%20topolgy%3CBR%20%2F%3E4.%20install%20the%20new%20pchat%20server%3CBR%20%2F%3E5.%20then%20import%20the%20database%20from%20the%20export%3CBR%20%2F%3E6.%20start%20the%20services%20on%20the%20new%20pchat%3CBR%20%2F%3Eand%20then%20check%20number%20of%26nbsp%3B%20rooms%2C%20categories%20and%20so%20on.%3C%2FP%3E%3CP%3EAnyone%20got%20any%20good%20advice%20%3F%3C%2FP%3E%3CP%3EBest%20Regards%3CBR%20%2F%3EKai%20Stenberg%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-15019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EInstant%20Messaging%20%26amp%3B%20Presence%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-15962%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Persistent%20Chat%20server%20from%20W2008R2%20to%20Windows2012R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-15962%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20so%20from%20what%20you%20say%2C%20I%20can%20export%20the%20data%20and%20then%20import%20them%20on%20a%20new%20database%20server%20and%20then%20place%20that%20into%20my%20SQL%20mirror%20cluster.%20And%20then%20we%20should%20be%20fine%20%3A)%3C%2Fimg%3E%20hopefully.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-15912%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Persistent%20Chat%20server%20from%20W2008R2%20to%20Windows2012R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-15912%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20cannot%20deploy%20multiple%20MGC%20databases%20on%20the%20same%20SQL%20instance.%20If%20you%20need%20to%20use%20the%20server%2C%20you%20should%20create%20an%20additional%20instance%20(on%20both%20servers%20in%20your%20mirror%20setup)%20and%20create%20a%20DNS%20CNAME%20for%20the%20new%20pChat%20server.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20get%20the%20rooms%20and%20messages%20from%20the%20old%20pChat%20server%20to%20the%20new%20pChat%20server%2C%20you%20should%20export%20persistant%20chat%20data%20using%20Export-CsPersistantChatData%20cmdlet%20and%20then%20import%20the%20data%20to%20the%20new%20pChat%20service%20using%20Import-CsPersistantChatData.%20Do%20not%20try%20to%20import%20a%20database%20from%20another%20pChat%20server%2C%20that%20will%20seriously%20break%20your%20new%20pChat%20service%20before%20you%20even%20get%20it%20started.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2FKenneth%20ML%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi, I have a customer that runs Persistentchat on a upgraded server who has windows2008R2 with Skype for Business. We want to move the whole Persistent chat into a windows 2012R2 (virtual) with skype for business running.
The customer has Skype for business Enterprise with SQL server 2012R2 running mirroring mode. Since databases are located on the SQL01 server in the mirror, well I am not sure about how to build the new server, export the database and put it back on the "SQL01".
To export was no problem but I can't use the SQL again.
Must I to it like this?
1. Create a new Persistenchat server in the topology
2.  name the new database server
3.  install a new SQL server import the PersistentChat database on that server and then publish the topolgy
4. install the new pchat server
5. then import the database from the export
6. start the services on the new pchat
and then check number of  rooms, categories and so on.

Anyone got any good advice ?

Best Regards
Kai Stenberg 

2 Replies

You cannot deploy multiple MGC databases on the same SQL instance. If you need to use the server, you should create an additional instance (on both servers in your mirror setup) and create a DNS CNAME for the new pChat server.

 

To get the rooms and messages from the old pChat server to the new pChat server, you should export persistant chat data using Export-CsPersistantChatData cmdlet and then import the data to the new pChat service using Import-CsPersistantChatData. Do not try to import a database from another pChat server, that will seriously break your new pChat service before you even get it started.

 

/Kenneth ML

Hi, so from what you say, I can export the data and then import them on a new database server and then place that into my SQL mirror cluster. And then we should be fine :) hopefully.