Configuring SQL Granular recovery (GRT) BackupExec 2015 in a Vmware Environment

[R2D2_SECURE]

Hi Community,

Does anybody knows how to enable GRT (Granular recovery) to recover an SQL Table  in the Following Environment:

Vmware: 5.1.
Windows Server 2008 R2
SQL 2008
BackupExec 2015

We have a compellent Storage conected to a FC SAN (Brocade) and couple of Poweredge Servers as ESX Hosts. 

The BE console in installed on a Physical Server.

BR.

[CraigV]

Check out the best practices link below which will help you with this:

http://support.symantec.com/en_US/article.HOWTO74443.html

The last section is what you are interested in.

Thanks!

[Colin_Weaver]

GRT wthin SQL level has a smallest object of a database - the GRT reference is because you can restore indvidual databases within a single instance (and from within the VM) and do not have to restore the whole instance (or VM) in one go. 

As such to get back one table you will probably have to redirect the restore to a different SQL instance and then use SQL Utilities/Scripting to get the data migrated to the restored copy back to where you want the data.

To do the GRT backup in the first place you just enable application  GRT against the VM backup (and make sure that the Agent For Windows software is installed inside the VM)

[R2D2_SECURE]

Thank You! Great Response.

[pkh]

Be careful when you try to recover a table, you might end up with a logically inconsistent database because a transaction may update a few tables at the same time.

[Karonoz]

To get GRT to run succesfully against Exchange you must do the following:

First, you must have all updates and feature packs to latest version.   Backup Exec 2015 is now on FP2

https://www.veritas.com/support/en_US/article.000023324

If you run FSUtil fsinfo ntfsinfo ?:  on the drive letter.  Check the Bytes per sector and the Phisical Bytes per sector

I found that Bytes per sector and the Phisical Bytes per sector on your backup drive, Exchange database drive as well as Exchange logs drive MUST match for GRT to work properly

See image 1 and image 2

Next under setting you must change the location of were the temp files for the GRT and NTSF go to the drive that matches.  It is defualted to C:\temp.  This must be redirected to the drive that matches the EXchaneg and backup drive

See image 3

You also must add the follow registry key to specify where the temp file location is on the backup server. Run Regedit:   HKLM\Software\Symantec\Backup Exec For Windows\Backup Exec\Engine\Exchange    Add a new sting Value OnHostTemp    And set the value to <Drive>:\Temp

See image 4

Restart the Backup exec Media service and then try your GRT backup.  It should work  :)

[Colin_Weaver]

Not sure why you posted details specifically about Exchange in a question about SQL

However as you posted it and mentioend FP2 - please be aware that the latest FP for BE 15 is FP3

More info on release here: https://www.veritas.com/community/blogs/introducing-backup-exec-fp3

Download, within attachments link, on this page: http://www.veritas.com/docs/000094416