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 the master database
Open the SQL Server Management Studio.
Open a new query window and type:
restore headeronly from tape_backup1
If tape_backup1 is not defined, type:
restore headeronly from tape='\\.\Tape0'
If the tape cartridge was ejected, reinsert it.
To run the command, click Execute.
Open SQL Server Configuration Manager.
To start SQL Server in single user mode, open a command prompt and type:
sqlservr.exe –m
Open another command prompt and type:
sqlcmd /E
Type:
use master
go
restore database master from tape_backup1
go
The master database is now restored.
Exit and restart the SQL Server Management Studio.