The video linked to is a part of the NetBackup Support Screencast Demo Video series. It demonstrates Performing an Exchange 2010 Database Restore to a Database Availability Group (DAG) with NetBackup 7.0.
TRANSCRIPT OF VIDEO:
Welcome to the NetBackup Support Screencast Demo Video series.
These videos deliver how to demonstrations in a variety of NetBackup functions.
They assume fundamental NetBackup knowledge.
If you need basic NetBackup training, please go to http://education.symantec.com where you will be able to find a listing of instructor-led classroom training as well as self-paced computer-based courses for NetBackup.
This video is Performing an Exchange 2010 Database Restore to a Database Availability Group (DAG) with NetBackup 7.0.
For this demonstration, we will be using a master/media server running NetBackup 7.0 on Windows 2003 R2 SP2, and an Exchange 2010 DAG with 2 members, both running NetBackup 7.0 on Windows 2008 R2.
This video does not apply to:
Restores to a non-DAG system
NetBackup versions prior to 7.0
To start, we need to work on the Exchange mailbox server to suspend replication and dismount the database we are going to restore. In the Exchange Management Console, we click on Organization Configuration, then Mailbox. Under the Database Management tab, then the Database Copies tab in the lower pane, we click on the replica copy of the database we want to restore. Then we click on Suspend Database Copy under Actions. We click Yes to confirm suspending replication. The copy status will then change from "Healthy" to "Suspended". Now we click on the mounted copy of the database and click on Dismount Database under actions. We click Yes to confirm dismounting the database and we see the copy status is now "Dismounted". We then click Properties under actions for the dismounted copy of the database, and under the Maintenance tab we click the checkbox for the This database can be overwritten by a restore setting and then click OK. No other steps should be required, and Exchange is now ready for the restore.
NetBackup – selecting the DAG for restore
After preparing the client, we will bring up the master/media server and go into the Backup, Archive, Restore (or BAR) GUI. We start by going to the File menu and clicking on Specify NetBackup Machines and Policy Type. In the resulting window, we set the source and destination to be the Exchange 2010 DAG name. We also set the Policy type to MS-Exchange-Server. We could also perform the restore using the BAR GUI on a DAG member. We would just need to make sure the DAG member host has permission to browse the backup images under the DAG name. We click OK on the Specify NetBackup Machines and Policy Type window.
Selecting images for restore
Next, we click on the Select for Restore button. Initially, we see the backup images in a Timeline view. It doesn’t provide much information about each backup, fulls are green and differentials are blue. It is recommended to go to the View menu and deselect the Show NetBackup History as a Timeline setting as we are doing here to get more information about each backup, including the specific time backed up. To select multiple images for restore, we click on the full backup we want to restore and then, holding down the <shift> key, we select the differential image up through which we want to restore. This will select the full image and all differential images we want to restore through.
Next, in the All Folders pane in the BAR GUI, we drill into the Information Store and click on the database that we want to restore. Then, in the lower right-hand pane, we click the checkboxes for the database and log files we want to restore.
Differential backups will back up the transaction logs and then truncate. Thus, they only contain the logs since the most recent full or differential backup. This is why we selected 1 log file backups in addition to the logs from the full backup, because each one was a differential backup and truncated the logs after it was complete.
No cumulative backups are shown here, but note that they do not truncate logs. Because of this, they contain all log files since the last full backup. They have the disadvantage of each successive cumulative backup being larger because it includes all logs since the last full, whether those logs had been backed up before or not. However, the benefit is that in a restore, you only need to select the last full backup and the most recent cumulative backup.
Setting restore options
Once we've marked all the files we want restored, we click on the second icon down on the left-hand toolbar, which is the Start Restore of Marked Files. This brings up the Restore Marked Files dialog. We click on the Microsoft Exchange tab. We see two options for replaying log files, Roll-Forward Recovery and Point-in-time recovery. With the Point in Time recovery option, only the logs being restored are replayed. The Roll-Forward recovery option will replay all restored logs, but will then continue with rolling forward any other log files that may exist on the system since logs were last truncated. For this demonstration, we will choose Roll-Forward Recovery.
The Temporary location for log files setting is unavailable, as it is unnecessary for an Exchange 2010 database restore.
We see a Dismount database prior to restore option. We have already dismounted the database we are restoring, so this option should remain deselected. Please note that anytime a database needs to be dismounted, it is recommended that dismounting be done from either the Exchange Management Console or Exchange Management Shell. This ensures that the correct database is dismounted. Using the option here only could result in the wrong database being dismounted and overwritten, if the restore does not use the intended database destination.
The next two options are Commit after last backup set is restored, which tells Exchange to recover the database after we restore the full and all log files, and Mount Database after restore, which will actually mount the database after it is recovered. These are both selected by default. However, please check with your Exchange Administrator to ensure they are appropriate actions at the end of your restore.
The last option, Redirect to Recovery Storage Group (Only for Exchange 2007), as the name implies, is only for Exchange 2007; so we will leave it unchecked.
Initiating the Restore
Since we are restoring back to the original database we do not need to change any settings under the General tab, so we will click the Start Restore button. A message will appear indicating the restore has successfully initiated. We click Yes to see the View Status window.
In the Activity Monitor of the NetBackup administration console, we see the restore job and can double-click on it to see detailed status. In the Job Overview tab we can see our database and the log files from the full and two differentials. In the Detailed Status tab, we can see some further information about the progress such as connecting to the client and starting the bptm process to read from the images. For this demonstration, we should see 2 sub-jobs start as part of Job ID 386, namely we should see 2 different restores, one for the full and one for the two differential.
If we go back to the BAR GUI’s view status window, we will see similar information. For instance we can see that we have a status 0 on the full with 6 of 6 files successful. The next job is the differential with a status 0 and 5 of 5 files. We also see that there are messages about remaining jobs. After the first job, it said there was one job remaining and, therefore, recovery would be deferred. After the last differential, it says there were no jobs remaining and recovery will be performed. We can see here after the last differential, there is a status 0.
Looking in Activity Monitor, we also see the job with a blue man and a status 0. On a restore, any final status other than 0 should be considered an unsuccessful restore and the cause should be investigated and the restore retried.
Let’s go back to the client and look at the Exchange Management Console. The restored database appears to be dismounted, but when we click on Refresh under Actions, the status is updated to reflect that the database is, in fact, mounted. We also click on the database copy in a "Suspended" status, then resume replication by clicking on Resume Database Copy under actions, and then clicking Yes on the confirmation dialog box. Depending on the restore scenario, it may be necessary to update the database copy instead of resuming replication, although we are not doing that here. Again, please check with your Exchange Administrator to ensure the appropriate actions at the end of your restore.