1 of 1 people found this helpful
Yep, that should be it! You will copy EVERYTHING from server 1 to server 2, except configuration parameters such as server IP's.
Here's the documentation: http://onlinehelp.tableau.com/current/server/en-us/help.htm#db_restore.htm
Thanks for the reply John.
Does this process erases all the existing data on server 2 ?
I Want server 2 data to be erased off before server 1 data get copied on to that.
2 of 2 people found this helpful
If that's the case, you need to do a clean uninstall of server 2 then reinstall Tableau Server. After that, you can restore server 1's backup to server 2.
To Perform a Clean Uninstall of Tableau Server:
1. Log into the Windows machine on which Tableau Server is installed as an Administrator
2. Open a Command Prompt as an administrator and navigate to the Tableau sever installation. Default installation directories:
+ On a 32-bit machine: C:\Program Files\Tableau\Tableau Server\[version]\bin
+ On a 64-bit machine: C:\Program Files (x86)\Tableau\Tableau Server\[version]\bin
3. Type the tabadmin stop command to stop Tableau Services
4. From the Start menu, go to Control Panel > Programs and Features, click Tableau Server, and then click the Uninstall button.
5. Delete the Tableau Server folder from the following locations:
+ On a 32-bit machine: C:\Program Files\Tableau\Tableau Server
+ On a 64-bit machine: C:\Program Files (x86)\Tableau\Tableau Server AND C:\ProgramData\Tableau\Tableau Server
**"program data folder may be hidden, check this link to see hidden folders Show Hidden Files and Folders in Windows 7, 8.x, 10, or Vista
6. Restart the Windows machine hosting Tableau Server. This should stop any running Tableau processes.
7. Now you are ready to restore or reinstall Tableau Server. Please note a clean uninstall erases all content and server settings -- Only do this to start fresh or to restore a backup for troubleshooting purposes.
Other than uninstall is there any option to do that?
Just for info. When copying to new server, make sure of creating new "Tableau" folder in the C or E directory (by default it could create in C drive). But take this step if in E drive. And keep checking if the config, log files are getting copied into "Program Data" folder in C drive, if your plan is to create in E drive.
Check all tableau folders such as the log, configs, gets installed in one place.
note down all the changes, and perform them on new server.
If you have cluster setup, make sure of that setting too. Domain, IP address of new server in reference to worker node.
Also make sure you have run as a user acct user name and password
Copy all the backups, backup that gets created with uninstall process to a complete new place.
Also if you have some dev box server, would be nice of taking the backup, and check restoring in dev server and see how it goes.
I have a question in this. Do one have to deactivate the server keys in old server, and activate again in new server in Su Ve's process. This is while completely uninstalling tableau in old server, and installing in new server.
Yes, if the hardware or VM changed, please deactivate old license.
I've tried that and it's not doing anything.
I installed v 9.0 server but at the end of the installation the file store says it's
synchronizing and carries on showing the message even though there are no
transfers pending when hovering.
After I type tabadmin restore --no-config tabserv.tsbak
should there be messages that come up or is there a time lag?
And by the way is it always better to include the no config option for a faster install?
Along with the backup file, the file path should be mentioned.
No config is done coz of some data related to old server shouldn't get
copied into another new server. You can look into details on this .
Below are my notes on file store. You can double check too. On the snap shot it's jus showing the File store is sync as it shows. That's normal process. Especially, i have seen that a lot after restoring backups.
- File Store will install in any node, that has data engine configured.
- This process manages the storage and replication of extract files between nodes.
- When this process fails, replication of extract files to and from the affected nodes stops. The new files added to the failed file store node will not be available on any other file store nodes in the cluster. Once the failed file store process is up, it ensures sync between File Store on each node.
I understand all that, but the problem is that when I install the Tableau server, this is a
permanent state, it is forever synchronizing and that isn't normal. If that's the case what is the underlying problem
and how can I address it?
Sorry that's beyond my scope.
Raise ticket wid tableau support.
They will look into ur tableau version and hardware configuration to give
when you get the solution, if u dont mind, can u also pls share wat was the issue wid me .
On Tuesday, March 8, 2016, Andrew Davis <firstname.lastname@example.org>