1. Back up the transaction logs > 2. Restore the master database > 3. Restore the additional databases > 4. Restore transaction logs > 5. Test the restored database
This procedure applies to SQL Server 2005.
Only experienced personnel should restore a database from a backup. Contact your service representative to complete these tasks.
 | Note: Ensure that you are logged in using the AgfaService account; you cannot log into SQL Management Studio using the Administrator account. |
To test the restored database
Open SQL Server Management Studio.
Open a new query window.
Type:
sp_database_check
To run the command, click Execute.
If no errors are returned, the restore was successful. If errors are returned, attempt to restore the databases again.