Home > SI5 Documentation > User Guide > Support Solutions > FAQs > Manual backup > Manually Moving SI5 Server

Manually Moving SI5 Server

Manually Moving SI 5 Server Components to another Machine

This document shows the step by step procedure for manually moving your SI 5 Server Components data to another machine. This procedure should only be used if you are not able to use the built-in backup/restore functionality in SI5, perhaps due to a machine crash.  This post shows the preferred method for moving your SI5 Server.

Please Note: the paths given in this document are the default paths installed by SI5. The actual paths on your machine may vary.

Actions – Current Server Machine

First you will need to copy the files needed from the old server machine to the new server machine. Or you can place these files in shared folders on the old server that is accessible from the new server.

  1. Make copies of the following files/folders. We recommend creating three separate folders called “Projects” “Products” and “Databases” and place these files/folders accordingly.

Projects:

C:\DToolsData\Projects

Products:

C:\DToolsData\Products

Databases:

  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsProducts50.mdf
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsProducts50_log.LDF
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsProjects50.mdf
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsProjects50_log.LDF
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsUsers50.mdf
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsUsers50_log.LDF

*MSSQL.1 – the number may vary depending on how many instances of SQL you have installed on your machine.

  1. Uninstall the server components from the old server using Add/Remove Programs

Actions – New Server Machine

  1. Install the SI5 Server Components and update to the latest release: (Start->Program Files->D-Tools->Check for server updates)
  2. Open the services administrative tool and stop the service called “D-Tools System Integrator Services” (Start->Run->services.msc).  Right click the service and select "Stop".
  3. Now you will need to copy the files from the three folders created earlier to their appropriate places on the new server. Overwrite files if Prompted
  • C:\DToolsData\Projects
  • C:\DToolsData\Products
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsProducts50.mdf
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsProducts50_log.LDF
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsProjects50.mdf
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsProjects50_log.LDF
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsUsers50.mdf
  • C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\DToolsUsers50_log.LDF

*MSSQL.1 – the number may vary depending on how many instances of SQL you have installed on your machine.

  1. Open the services administrative tool and start the “D-Tools System Integrator Services” (Start->Run->services.msc).  Right click the service and select "Start".

The complicated stuff – detaching and attaching databases

Now the databases will have to be detached and reattached.

We recommend using Microsoft SQL Server Management Studio Express to accomplish this. This is free and can be downloaded from http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Install this handy tool and keep it around.

Detaching

  1. Open Microsoft SQL Server Management Studio Express
  2. Click Connect. Login to the correct SQL instance,  this is usually called "DTOOLSV5.
  3. Click on “Databases” in the Object Explorer section

1

  1. Select the DToolsProducts50 database in the Summary section, right-click and select Tasks-> Detach…

2

 

  1. The Detach Database form will open Check "Drop Connections" and "Keep Full Text Catalogs" then Click [OK].drop_connections.jpg

 

  1. The database is removed from the list:

     

4

  1. Repeat steps 4 and 5 for the other two databases: DToolsProjects50 and DToolsUsers50.

 

Attaching

  1. In the Microsoft SQL Server Management Studio Express interface, right-click on “Databases” in the Object Explorer section and select Attach… The Attach Databases form will open.

5

  1. Click the [Add...] button on the Attach Databases form. The Locate Database Files from will open.

6

  1. If necessary, expand the tree to the path C:\Program FilesMicrosoft SQL Server*MSSQL.1MSSQLData and select the D-ToolsProducts50.mdf file and then click [OK]:

*MSSQL.1 – the number may vary depending on how many instances of SQL you have installed on your machine.

7

  1. Click [OK] on the Attach Databases form:

8

 

  1. Repeat steps 4-7 of this section. For step 6, you will choose the other two databases: DToolsProducts50.mdf and DToolsUsers50.mdf.

Fixing the login for the databases

  1. Right-click one of the databases you just reloaded and select “New Query”

9

  1. Type the following line of code verbatim, select all the text and click [Execute]:

sp_change_users_login 'AUTO_FIX','DToolsData'

10

  1. You will see the following confirmation that one orphaned user was fixed.

11

  1. Repeat for the remaining databases. When you close the SQL Management Studio you will be prompted to save your queries, select [NO].

Services

  1. Once you have the login fixed for all three databases.
  2. Open Services via Start-> Run-> Services.msc
  3. STOP “D-Tools System Integrator Services” Service
  4. START “D-Tools System Integrator Services” Service

Logging in from Desktop Machines

When logging into SI 5 from a Desktop Machine, make sure you type in the name or IP address of the new Server Machine in the Server field:

File:Si5Wiki/SI5/Support_Solutions/FAQs/Manual_backup/Manually_Move_SI5_Server/login_screen.jpg

Once logged in, you will need to click the "Sync product data" link to re-establish your local database from the new server:

File:Si5Wiki/SI5/Support_Solutions/FAQs/Manual_backup/Manually_Move_SI5_Server/sync_product_data.jpg

Also, double-check that you restored your databases correctly by choosing "Server" from the Show dropdown menu on your Projects tab:

File:Si5Wiki/SI5/Support_Solutions/FAQs/Manual_backup/Manually_Move_SI5_Server/server_view_for_projects.jpg

You must to post a comment.
Last modified
08:33, 28 Jul 2014

Tags

This page has no custom tags.

Classifications

This page has no classifications.