Grass Valley Aurora Transfer v.6.0b - Manual (Page 69)

September 11, 2006 Aurora Transfer Instruction Manual 69
Database Restoration
36.Click the OK button and verify the schedule.
37.Click the Next> button to navigate to the Specify Transaction Log Backup Disk
Directory page.
38.Select the Use the default backup directory radio button, except if the site has a
specific folder for database backup files. If that is the case, then select the Use this
directory radio button and enter in the specified path. (Note: SQL can only see local
drives and cannot see shared directories or disks that are not native to the machine.)
39.Select the Create a subdirectory for each database check box.
40.Select the Remove files older than check box and set the value to 1 week(s) .
41.The backup extension should be set to TRN .
42.Click the Next> button to navigate to the Reports to Generate page.
43.Click the Next> button to navigate to the Maintenance Plan History page.
44.Click the Next> button to navigate to the Completing the Database Maintenance Plan
Wizard page.
45.Enter Aurora Transfer for the name of the schedule.
46.Click the Finish button. (Note: If an error occurs, it is most likely that your
SQLSERVERAGENT was not started. Start the service and start over.)
If the SQLSERVERAGENT is ever stopped, so is your maintenance plan. Make sure
that the service is set to auto start in case of a reboot.
Database Restoration
When Aurora Transfer is installed, a maintenance plan should be implemented to
schedule backups of the MediaFrame database 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 database 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: