Database restoration – Grass Valley NewsBrowse Desktop Browsing System Installation v.2.7 User Manual
Page 128

128
NewsBrowse Installation and Configuration Guide
December 16, 2004
Chapter 4 Recovery Planning
Database Restoration
When NewsBrowse is installed, a maintenance plan should be implemented to
schedule backups of the MediaFrame and NBIngest databases and transaction logs.
The rule of thumb in restoring the database is to restore the last successful database
backup and transaction log backups preceding system failure. Below is a given
scenario of a system failure and the steps necessary to recover.
• 2:00:00 AM database back up performed by the maintenance plan
• 8:00:00 AM transaction log is backed up by the maintenance plan
• 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 NewsBrowse 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. Repeat the above steps for the NBIngest database.