cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot find/See SQL backup selection on Windows Cluster

Moti2015
Level 3

Clients environment:
Windows Cluster
Client - Windows 2008 R2 Ent SP1
With SQL 2012 Ent
Two Node - Active /Passive

Backup Exec Version
Backup Exec 15 FP1
Backup Exec Server: 14.2 Rev 1180 64 bit
Backup Exec Client: 14.2.1180.1162

We Cannot find/See SQL backup selection -
We See All other Resources on Cluster fine

Before we upgrade to BE15 everything works right - Include Backup SQL DataBase on Windows Cluster
Previous version Was Backup Exec 2010 R3

8 REPLIES 8

VJware
Level 6
Employee Accredited Certified

First, try removing and readding the Agent for Application & Database license.

Secondly, in newer versions of BE, one cannot have SQL specific credentials. So, do ensure the BE account has necessary permissions such as "sa".

Moti2015
Level 3

1. We used license of Capacity Edition

2. We have other systems with SQL Server and SQL on Windows Cluster that we successful to backup the SQL

3. We Re-Install the BE Agent on each node on the cluster and reboot the system and 

We still do not see the SQL Database backup Selection when we try to run backup, we see only the Cluster drive with all the data files. 

 

Moti2015
Level 3

The BE Account have full  permissions such as "sa" in the SQL Cluster database

We check the user with microsoft sql server management studio and it work fine

VJware
Level 6
Employee Accredited Certified

Do you see the SQL instances when viewed via the node itself directly ?

Have you tried removing the virtual IP from the Backup & Restore tab and readding it ?

Moti2015
Level 3

1. I don't see  the SQL instances via the node itself directly on the backup Selection of the active node

2. I remove the virtual IP from the Backup & Restore tab and re-adding it, and I still don't see the SQL Database backup Selection and only the cluster share drive with all the data files. 

VJware
Level 6
Employee Accredited Certified

Pls enable SGmon debugging on the BE server and both the SQL nodes.

Try browsing the selection list again and pls post the debug logs over here as an attachment.

An alternative would be to log a support case and have an engineer work with you directly. Thanks.

Moti2015
Level 3

I enable the debug mode

The log attached when i open the backup selection of the virtual ip(cluster)  and not see the SQL Instance 

 

BEDebugMonitor.JPG 

 

 

 

VJware
Level 6
Employee Accredited Certified

The debug has to be enabled on all appropriate servers and not just one.

Secondly "verbose" mode may be required for the beremote debugging.

Lastly, attach the debug files from all servers and not a screenshot. Thanks.