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 and to SQL Server 2008.
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 back up the transaction logs
Open the SQL Server Management Studio.
In the Object Explorer window of the SQL Server Management Studio, expand <server> > Databases
where <server> is the name of the SQL Server that the program is running under.
Right-click the database to back up the transaction log for and select Tasks > Back Up.
In the Backup Database dialog, under Backup Type, select Transaction Log.
Under Destination, select the backup type appropriate for the system.
Click Add.
In the Select Backup Destination dialog, select the location to back up the transaction log to and click OK.
Select Options > Overwrite media.
Select Overwrite all existing backup set. Click OK.
The transaction log is backed up. If you have more databases to restore, repeat the procedure to back up the transaction log for each database.
Next, restore the master database.