cancel
Showing results for 
Search instead for 
Did you mean: 

VMware Policy Application Protection for SQL not working - Status 47

user022013
Level 4
Partner Accredited Certified

Hi Gurus,

I have Windows 2012 virtual servers backing up to a  NBU 7.5.0.5 environment.  They are SQL 2012 servers. 

Prior to the creation of Windows 2012 SQL servers we were successfully backing up SQL using the NBU SQL client. 

The literature suggests that I could use a VMWARE policy with 'Enable SQL Server Recovery' option to get a SQL database backup.

I get a successful VM backup but the SQL component fails with Status 47. 

JOB DETAILS ARE:

5/24/2013 10:47:47 AM - estimated 0 Kbytes needed
5/24/2013 10:47:47 AM - begin Parent Job
5/24/2013 10:47:47 AM - begin Application State Capture, Step By Condition
Status 0
5/24/2013 10:47:47 AM - end Application State Capture, Step By Condition; elapsed time: 00:00:00
5/24/2013 10:47:47 AM - begin Application State Capture, Application State Capture
Status 47
5/24/2013 10:48:10 AM - end Application State Capture, Application State Capture; elapsed time: 00:00:23
Status 47
5/24/2013 10:48:10 AM - end Parent Job; elapsed time: 00:00:23
host is unreachable(47)

 

Any ideas?

3 REPLIES 3

RLeon
Moderator
Moderator
   VIP   

ACS has a few prerequisites:
- The Nbu client must be installed in the guest OS, with network connection and proper forward/reverse name lookups between the Master/Media servers and the VM.
- VMware Tools must be installed.
- Install the Symantec VSS provider on the virtual machine. (Some would argue this is optional...)
- The Enable file recovery from VM backup option must be enabled.
- The Enable block-level incremental backup option must be disabled.

Perhaps it could be a connection problem between the master and the guest OS VM.

 

 

On the other hand, even though MS SQL 2012 is supported at the Nbu client/agent level, it is not yet supported with the current ASC implementation.

This information is, for some reason, not found in any publicly available NetBackup documents.
As a Symantec partner, you should be able to gain access to a document named NetBackup 7.5 Feature Briefing - Application Protection for VMware Virtual Machines. (May ask your SE)

Supported operating systems and databases: (ASC)

Windows Server 2003 and 2008
VMware ESX 4.x or 5.x  
SQL Server 2005 & 2008
Exchange 2007 and 2010 (x64)
SharePoint 2007 and 2010 (x64)

ASC support for MS SQL 2012 is not mentioned in any of the current NetBackup release notes.

 

Edit: The 7.5.0.5 release notes mentions VMware backups protecting SQL Server 2012. ASC support for MS SQL 2012 appears to be supported now. Hopefully someone in the know may be able to elaborate. (Would have liked for this to have been mentioned under the section titled NetBackup 7.5.0.5 new enhancements in the release notes...)

RLeon
Moderator
Moderator
   VIP   

I just noticed that the guest OS is Windows Server 2012 after rereading your post (Sorry!).


NetBackup does not yet support Windows Server 2012, so the ASC prerequisite could not be fulfilled.
The agent based backup of MS SQL 2012 is currently only (officially) supported when running on Windows Server 2008 SP2 or 2008R2 SP1.

Dollypee
Moderator
Moderator
   VIP    Certified

Hi Rleon, am having same issues. Please advice, am i suppose to manually add the client into e saparate policy?

Here my backup selection:  vmware:/?filter=VMDNSName Equal "CRPVMS2SQLCP3.central.nychhc.org"

am am getting this error:

11/21/2013 3:02:19 PM - Info nbjm(pid=4644) starting backup job (jobid=331130) for client CRPVMS2SQLCP3.central.nychhc.org, policy VM_Testing, schedule VM_Full 
11/21/2013 3:02:19 PM - Info nbjm(pid=4644) requesting MEDIA_SERVER_ONLY resources from RB for backup job (jobid=331130, request id:{4F6D66A3-6EFF-4101-BBC7-0F17CFBA7EA8}) 
11/21/2013 3:02:19 PM - requesting resource DD990-SDC-VM2
11/21/2013 3:02:19 PM - requesting resource crppms1vemmprd2.nychhc.org.NBU_CLIENT.MAXJOBS.CRPVMS2SQLCP3.central.nychhc.org
11/21/2013 3:02:19 PM - requesting resource crppms1vemmprd2.nychhc.org.NBU_POLICY.MAXJOBS.VM_Testing
11/21/2013 3:02:19 PM - granted resource crppms1vemmprd2.nychhc.org.NBU_CLIENT.MAXJOBS.CRPVMS2SQLCP3.central.nychhc.org
11/21/2013 3:02:19 PM - granted resource crppms1vemmprd2.nychhc.org.NBU_POLICY.MAXJOBS.VM_Testing
11/21/2013 3:02:19 PM - estimated 0 Kbytes needed
11/21/2013 3:02:19 PM - begin Parent Job
11/21/2013 3:02:19 PM - begin Application State Capture, Step By Condition
Status 0
11/21/2013 3:02:19 PM - end Application State Capture, Step By Condition; elapsed time: 00:00:00
11/21/2013 3:02:19 PM - begin Application State Capture, Application State Capture
Status 47
11/21/2013 3:02:23 PM - end Application State Capture, Application State Capture; elapsed time: 00:00:04
Status 47
11/21/2013 3:02:23 PM - end Parent Job; elapsed time: 00:00:04
host is unreachable(47)