YOUR STORY PLAYS HERE
Home » Categories » Multiple Categories

How do I migrate my database and content to another server?

 

Answer

 

*WARNING*

***Migrating databases and content from one server to another is a process for advanced users only and should not be attempted if you do not understand any of the steps laid out below***

PREPARING THE SERVERS:   

1)     Start by ensuring that the versions of Carousel and Front Door on the old server and the new server are the same. Perform a complete backup before getting started. That process is outlined here:

http://trms.knowledgebase.co/article/how-do-i-backup-my-carousel-server-22.html

2)     Make sure that SQL management studio is installed on the server to which you are moving the content/databases.

3)     Transfer the .bak files and the media folder over to the new server

4)     Once that is complete, you will want to stop the Carousel , Time Sync , and  Notifications  (in FrontDoor 5.5.1+) services to prevent access conflicts as you restore the databases. Select the Windows start button enter in services.msc to the universal search pane. Stop both the Carousel and TimeSync services. 

5)     Once the services are stopped, return to the start menu and enter iisreset into the universal search pane.

RESTORING THE DATABASES :

Now that you have the media folder and .bak files on the new server, we can begin restoring the databases.

1)     Launch SQL Management Studio on the server and click 'connect'

You will restore the databases one at a time:

2)     Right Click on the database you wish to restore:

Then select tasks>Restore>Database. Once you are on the 'Restore Database' Screen, select 'From Device' and select '...' to browse to the .bak files

Then Select 'ADD' 

Browse to the location of the .bak file for the Database you are restoring, highlight it and select 'OK'. Select 'OK on the next screen as well.

Now you are back to the 'Restore Database' Screen(Pictured below)

Check the 'Restore' box 

Then you will want to select 'Options' in the upper left:

Under 'Restore Options' there is an option to 'Overwrite Existing Database'

Select the check box to confirm that option.

Select 'OK' at the bottom of the active window to execute the restoration. Upon completion, you will get a message which reads "Restore Completed Successfully" 

Once you have restored Both the Carousel and Front Door databases, go ahead and move the Media folder from the old server to the same location on the new server (Use Copy and replace for all when prompted).

Once that is copied and in place, go ahead and re-boot the new server.

 

Additional Information

As is stated above, this process is for advanced users only. Our Professional Services department does offer Migration assistance as a service. For more information on procuring this service, please contact professionalservices@trms.com

 

4 (1)
Article Rating (1 Votes)
Rate this article
  • Icon PDFExport to PDF
  • Icon MS-WordExport to MS Word
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Broadcast Products: End of support for Microsoft Windows XP and Windows Server 2003
Viewed 1825 times since Fri, Jul 24, 2015
Can I use SSL to protect my signage content?
Viewed 1251 times since Thu, Aug 20, 2015
Locating my hardware license key
Viewed 3095 times since Wed, Sep 17, 2014
How do I combine two Carousels into one?
Viewed 712 times since Thu, Oct 13, 2016
Channel Showing Black When Switching To Carousel
Viewed 1949 times since Mon, Jun 29, 2015
Where can I download Carousel virtual machine images?
Viewed 1309 times since Tue, Dec 8, 2015
What is a Carousel "DSS"?
Viewed 315 times since Wed, Aug 16, 2017
What features of Carousel require a Multicast enabled network?
Viewed 757 times since Tue, Oct 4, 2016
Error from RabbitMQ about unreachable endpoints
Viewed 4762 times since Mon, Feb 16, 2015
Matrox Convert DVI Power Supply
Viewed 1566 times since Mon, May 4, 2015