If you experience database problems, you may need to restore the database from a backup. If you have enabled differential or incremental backup jobs, refer to Restoring the SQL databases when differential or incremental backup jobs are enabled. Otherwise, follow these instructions.
 | Note: Shut down all applications that usually connect to the SQL Server database. Also ensure that you are logged in using the AgfaService account; you cannot log into SQL Server Management Studio using the Administrator account. |
Restoring from a backup requires that you restore the master database, then the rest of the required databases (for example, msdb and mvf).
 | CAUTION! Only experienced personnel should restore a database from a backup. Contact your service representative to complete these tasks. |
Restoring the complete set of databases may require up to five steps:
Back up the transaction logs for each database.
The transaction logs contain the information that was written to the database from the time of the last tape backup until the time that the database experienced problems.
Restore the transaction logs for each database.