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
On the server, start the Microsoft Management Console.
Navigate to the Symantec Workflow Server service and click it.
Under Application Experience, click .
To stop the Default Web site on a ServiceDesk or Workflow server
On the server, start Internet Information Services (IIS) Manager.
On your server, under Sites, click .
Under Manage Web Site, click .
To create backups on a ServiceDesk or Workflow server
On the server, run the %systemroot%\system32\inetsrv\APPCMD add backup command to ensure that you have a current backup of the metabase.
%systemroot%\system32\inetsrv to your backup directory path.
Back up the directory path of SymQ, which is located in C:\Program Files\Symantec\Workflow\Data.
Back up the location of your ServiceDesk workflows.
The workflows are typically located in the C:\Program Files\Symantec\Workflow\WorkflowDeploy directory.
Locate and back up any additional workflows that you have created.
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 .
Restore the Process Manager MDF files and LDF files.
These files are located in the Microsoft SQL Server Management Studio.
Start Microsoft SQL Server Management Studio, right-click the SQL Instance that is running on your Microsoft SQL Server, and click .
Ensure that the database can be accessed and is attached.
Restore the SymQ C:\Program Files\Symantec\Workflow\Data directory path.
To restart the Default Web site
On the ServiceDesk server, start Internet Information Services (IIS) Manager.
Navigate to Default Web Site and right-click it.
In the Manage Web Site dialog box, click .
To restart the Symantec Workflow Server service
On the ServiceDesk server, start the Microsoft Management Console.
Navigate to the Symantec Workflow Server service, and under Applicaton Experience click .