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 restore transaction logs
In the Explorer window of the SQL Server Management Studio, right-click the database to restore the transaction log for and select Tasks > Restore > Database.
In the Restore database dialog, under Source for restore, select From device.
In the Specify Backup dialog, click Add. Click OK.
Under Select Backup sets to restore, select transaction log.
Switch to the Options tab.
The names of the transaction logs that you are restoring are displayed.
Clear the Overwrite existing database checkbox.
Select the first option. Click OK.
The transaction logs for the selected database are restored. After the restore is complete, a confirmation message appears stating whether the restore was successful. If you have more transaction logs to restore, repeat the procedure for each database.
Next, test the restored database.