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 restore additional databases
If you are restoring msdb, in SQL Server Configuration Manager, stop the SQL Server Agent.
If you are restoring from tape, insert the backup tape into the tape drive.
In the Explorer window of the SQL Server Management Studio, expand <server> > Databases > System Databases
where <server> is the name of the SQL Server that the program is running under.
Right-click the msdb database and select Tasks > Restore > Database.
You must restore msdb first, then mvf.
In the Restore database dialog, beside Source for Restore, select From device.
Click Select Devices. Click OK.
Under Backup set to restore, select Database - complete.
Switch to the Options tab.
Select Overwrite the existing database.
If you are not restoring transactional logs, select Leave database ready to use by rolling back uncommitted transactions. Additional transaction logs cannot be restored.
If you are restoring transactional logs, select the second option.
Click OK.
The database is restored. After the restore is complete, a confirmation message appears stating whether the restore was successful.
To restore the mvf database, repeat the procedure, selecting the mvf database at step 4.
After restoring the mvf database, restore the mvf user permissions:
Open SQL Server Management Studio.
Open a new query window.
Select File > Open and browse to C:\mvf\etc.
Select recreate_user_mvf.sql and click Open.
To execute the script, press F5 or click Execute.
If you are not restoring transactional logs, test the restored database.
If you are restoring transactional logs, do so now.