beautypg.com

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

Page 128

background image

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.