Resource Dynamics, Inc.

Tele-Support HelpDesk Hot Tips

SQL Tech Tip:

I need to move my SQL database to a different computer.

I need to save my SQL database while I format the computer it is on.

Possible reason to move:

Moving to an updated server.

Rebuilding server.

Updating to new version of SQL.

Current server security has been compromised.

You will start by downloading and install the full installer (evaluation download) onto the new server.  PLEASE be sure you install the same version that you are currently licensed.  If you have an older version of HelpDesk, contact our office to see if we still have clean install available.

Once the full install is complete on the new server, remove the empty HelpDesk3.mdb.  This file is not used and will lessen the confusion for users to attempt to connect to the access database vs. the SQL database.

*IMPORTANT* Before moving a licensed version of HelpDesk, you MUST process a deactivation license on the current server.  This is required before a new license will be issued.  Only ONE permanent license is permitted at any one time. 

Then begin:

1- Make sure that everyone is logged out of Helpdesk before beginning.

2- From the Enterprise Manager right click the database and select All Tasks -> Detach Database... -> OK

3- Browse to SQL 2000 default:

       C:\Program Files\Microsoft SQL Server\MSSQL\Data

SQL 2005 default:

       C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

and move the Helpdesk3.mdf and Helpdesk3.ldf to the new location or a safe temporary place.

4- Once the new server is installed and the .mdf and .ldf files have been put back into the corresponding directory, from within the Enterprise manager right click on the Databases folder -> All Tasks -> Attach Database... and select the Helpdesk3.mdf -> OK.

5- If the database has been moved to a new server it may be necessary to redirect the HDConfig32.udl file to ensure Helpdesk picks the right location for the database. Browse to (on the new server):

       (example) C:\Program Files\HelpDesk3\Server\Configuration\HDConfig32.udl

and verify the server name and database then test the connection.    The HDConfig32.udl will automatically install with the full install.

Resource Dynamics is not responsible for any corruption or damaged that may be caused by moving our database.  Please take the proper steps required to ensure you have a SAFE backup of your database.