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 |
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:
Shut down the Symantec Workflow Server service.
See “To shut down the Symantec Workflow Server service on a ServiceDesk or Workflow server”.
See “To stop the Default Web site on a ServiceDesk or Workflow server”.
See “To create backups on a ServiceDesk or Workflow server”.
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.
Add
%systemroot%\system32\inetsrvto 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 Stop.
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 Start.
Restore the SymQ C:\Program Files\Symantec\Workflow\Data directory path.
|
|
Legacy ID
v63471398_v66564686
Article URL http://www.symantec.com/docs/HOWTO62373
Terms of use for this information are found in Legal Notices









Thank you.