11-30-2015 09:40 AM
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.
11-30-2015 11:09 AM
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!
11-30-2015 12:20 PM
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)
11-30-2015 01:28 PM
Thank You! Great Response.
11-30-2015 05:13 PM
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.
12-11-2015 12:53 PM
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 :)
12-14-2015 12:07 AM
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