Restoring the Workflow Process Manager database after a failure

Article:HOWTO62373  |  Created: 2011-12-13  |  Updated: 2011-12-20  |  Article URL http://www.symantec.com/docs/HOWTO62373
Article Type
How To


Subject


Restoring the Workflow Process Manager database after a failure

If the Process Manager database has been corrupted through application error or through hard drive failure, you must restore the database.

See About restoring data.

Restoring a database involves the following main steps:

To shut down the Symantec Workflow Server service on a ServiceDesk or Workflow server

  1. On the server, start the Microsoft Management Console.

  2. Click Services (Local).

  3. Navigate to the Symantec Workflow Server service and click it.

  4. Under Application Experience, click Stop the service.

To stop the Default Web site on a ServiceDesk or Workflow server

  1. On the server, start Internet Information Services (IIS) Manager.

  2. On your server, under Sites, click Default Web Site.

  3. Under Manage Web Site, click Stop.

To create backups on a ServiceDesk or Workflow server

  1. On the server, run the %systemroot%\system32\inetsrv\APPCMD add backup command to ensure that you have a current backup of the metabase.

  2. Add %systemroot%\system32\inetsrv to your backup directory path.

  3. Back up the directory path of SymQ, which is located in C:\Program Files\Symantec\Workflow\Data.

  4. Back up the location of your ServiceDesk workflows.

    The workflows are typically located in the C:\Program Files\Symantec\Workflow\WorkflowDeploy directory.

  5. Locate and back up any additional workflows that you have created.

  6. Take one of the following actions, depending on the nature of the failure.

    If a hard drive failed

    Install Microsoft SQL Server 2008 R2.

    Refer to the Microsoft Web site at http://msdn.microsoft.com/en-us/library/ms143219.aspx. Note that if you use a different version of Microsoft SQL, you should locate the correct installation documentation.

    If a database was corrupted

    Stop the Microsoft SQL Server Instance by performing the following steps:

    • Start Microsoft SQL Server Management Studio.

    • Right-click the SQL Instance that is running on your Microsoft SQL Server, and click Stop.

  7. Restore the Process Manager MDF files and LDF files.

    These files are located in the Microsoft SQL Server Management Studio.

  8. Start Microsoft SQL Server Management Studio, right-click the SQL Instance that is running on your Microsoft SQL Server, and click Start.

    Ensure that the database can be accessed and is attached.

  9. Restore the SymQ C:\Program Files\Symantec\Workflow\Data directory path.

To restart the Default Web site

  1. On the ServiceDesk server, start Internet Information Services (IIS) Manager.

  2. Navigate to Default Web Site and right-click it.

  3. In the Manage Web Site dialog box, click Restart.

To restart the Symantec Workflow Server service

  1. On the ServiceDesk server, start the Microsoft Management Console.

  2. Open Services (Local).

  3. Navigate to the Symantec Workflow Server service, and under Applicaton Experience click Restart the service.


Legacy ID



v63471398_v66564686


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


Terms of use for this information are found in Legal Notices