Grass Valley Aurora Browse v.6.0b Installation - Manual (Page 116)

116 Aurora Browse Installation and Configuration Guide September 22, 2006
Chapter 4 Recovery Planning
• 2:00:00 PM transaction log is backed up by the maintenance plan
• 2:30:00 PM system failure occurs
The basic steps to recover are as follows:
1. Restore the database backup done at 2:00:00 AM
2. Restore the transaction backup done at 8:00:00 AM
3. Restore the transaction backup done at 2:00:00 PM
With a database maintenance schedule in place, SQL already recognizes the most
recent database backup as well as the sequence of transaction log backups. To restore
the Aurora Browse databases to the most current state before failure occurred, open
SQL Enterprise Manager, expand the SQL Servers, expand the SQL Server Group,
expand the server node, expand the databases directory and do the following:
1. Right mouse click the MediaFrame database
2. Select All Tasks .
3. Select Restore Database…
4. Select the Database radio button.
SQL automatically selects most recent database backup file and sequence of
transaction logs.
5. Verify the date and time stamp.
6. Click the OK button.
SQL will first restore the database, then restore the first transaction log backup, then
restore the proceeding transaction logs up until the point of failure. After restore has
completed the database will be restored to the point in time of the last backed up
transaction log.