Move a SQL database to a new server

To view these instructions in a printable PDF format, download the files at the bottom of this page.

New Server setup:

Create a new SQL Server instance and install SQL Server Management Studio. Any SQL server from 2005 and newer can be used. Installation steps for 2012 R2: http://help.protracker.com/hc/en-us/articles/211930326

 These are the steps that should be completed:

1. Install SQL Server installation / instance

2. Install SQL Server Management Studio

3. Enable TCPIP and Named Pipes, enable SQL browser service

4. Disable firewall to allow client connections

 

Workstations:

Close ProTracker Advantage on all workstations.

 

Old Server:

Make a backup or Detach/copy your database from the old SQL Server.

See this article for more information on these steps: http://help.protracker.com/hc/en-us/articles/211930386

  1. Open SQL Server Management Studio, 
  2. Locate ProTrackerAdvantage database in the list of databases.
  3. Detach the database or make a backup copy : Right-click> Tasks > Detach or Tasks> Backup
  4. detach.png

 

New Server Installation

  1. Move the database files or the .bak file to its new location on the new server (2 files - .mdf and .ldf). A typical location will be C:\Program Files\ProTracker Advantage or create a new folder on your specific data drive.
  2. Attach your database to the new SQL Server instance using SQL Server Management Studio. (Right-click> Tasks > Attach or Tasks> Restore)
  3. restore.png
  4. Make sure the new server's firewall is disabled or allows SQL traffic.
  5. Make sure the new SQL Server is configured to allow TCP/IP and Named Pipes.
  6. namedpipes.png

 

Workstation after the database is moved

  1. On each workstation, open ProTracker Advantage. You will be prompted to connect to a database.
  2. Enter the connection information for the new server if needed. The defaults are:
    Auth: windows
    Server: [SERVER_NAME]\SQLEXPRESS
    Database: ProTrackerAdvantage

  3. If a workstation is unable to connect to the database after the move, see this article:http://help.protracker.com/entries/37850345

Documents and Photos

Please note that you may also need to move the Documents folder to the new server. Try to keep the path to the documents exactly the same. Go to Operations> Database Admin to view the current path. If you remap the mapped drive to the new location, the files paths will allow the links in ProTracker to work.

 

Running earlier SQL Server version on Windows Server 2012

To run a pre-2012 version of SQL Server 2008 on Server 2012 you have to install SQL Server 2008R2 SP3 and .Net 3.5 has to be enabled, which might not be on a new server.  More info here: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8dfb2cc5-eac5-4d57-9dad-f858d3c0f0c8/is-sql-2008-compatible-with-windows-server-2012?forum=sqlsetupandupgrade

Have more questions? Submit a request

0 Comments

Article is closed for comments.