How to migrate a ServiceDesk 7.0.x server and SQL Server to new servers

Article:HOWTO21544  |  Created: 2010-01-26  |  Updated: 2012-01-24  |  Article URL http://www.symantec.com/docs/HOWTO21544
Article Type
How To



This article describes how to migrate ServiceDesk to a new server and also how to migrate the SQL Server to a new SQL Server.
Note: These instructions are intended for ServiceDesk 7.0.x the SD 7.1.x version of this KB can be found at: http://www.symantec.com/docs/Howto65815.

How to Migrate the ServiceDesk Microsoft SQL Server

  1. On the ServiceDesk server, close Workflow Designer and Process Manager if they are open.
  2. In Windows, click on the Start button > Administrative Tools > Services.
  3. Locate the LogicBase 2006 Server Extensions service, right click on it and click on Stop.
  4. Click on the Windows Start button > Run.
  5. Type IISRESET /STOP.
  6. Click on the OK button.
  7. Backup any customized Workflow projects. Project folders are stored in the <ServiceDesk_installation_drive>:\Program Files (x86)\Altiris\Workflow Designer\WorkflowProjects folder. Note: If customized projects are not backed up, these may be overwritten by the reinstall of ServiceDesk, performed later in these instructions. If so, there is no method to recover these unless a backup has previously been performed on them. For more information on how to backup and restore project customizations, please refer to the following article:

    How to backup and restore ServiceDesk Workflow project customizations
    http://www.symantec.com/business/support/index?page=content&id=HOWTO36202
     
  8. If the existing database is to be migrated, using Microsoft instructions or referring to your DBA, copy the Ensemble database from the original SQL Server to the new SQL Server. Note: ServiceDesk 7.0 is designed to be used with SQL Server 2005 (32 or 64-bit). Support for SQL Server 2008 will be added to a future version of ServiceDesk.
  9. Reinstall ServiceDesk by following instructions from KB HOWTO31346. During the reistall, choose Upgrade and then choose the new database server. Do not select to create a new database, unless the old database is not wanted any longer.

    How to Install and run ServiceDesk 7.0 MR2 with a domain account instead of local system account
    http://www.symantec.com/business/support/index?page=content&id=HOWTO31346
     
  10. Restore any customized Workflow projects.
  11. In Windows, click on the Start button > Administrative Tools > Services.
  12. Locate the LogicBase 2006 Server Extensions service, right click on it and click on Start.
  13. Click on the Windows Start button > Run.
  14. Type IISRESET /START.
  15. Click on the OK button.
  16. ServiceDesk should now be updated to use the new Microsoft SQL Server.

How to Migrate the ServiceDesk server

Use the above instructions but with the following changes:

  1. Skip step 8.
  2. For step 9, perform a New install not an Upgrade install. Choose the existing database server and do not select to create a new database, unless the old database is not wanted any longer.

Troubleshooting

If the name of the ServiceDesk server is changed and the original database is kept, this will result in issues. For example, e-mail messages with URLs will all be broken. Other references to the old server name will also no longer be valid. This will then require manual changes in various areas, such as Application Properties.

Related Articles

Are previous ServiceDesk customizations kept when upgrading or reinstalling
ServiceDesk?
http://www.symantec.com/business/support/index?page=content&id=HOWTO30327

After upgrading ServiceDesk, certain areas no longer work as they used to
http://www.symantec.com/business/support/index?page=content&id=TECH133473 


Legacy ID



51143


Article URL http://www.symantec.com/docs/HOWTO21544


Terms of use for this information are found in Legal Notices