If 'SQLINSTANCE $ALL' is used to backup all instances in a clustered MS SQL Server, the backup will fail with status 2.

Article:TECH129261  |  Created: 2010-01-26  |  Updated: 2013-10-27  |  Article URL http://www.symantec.com/docs/TECH129261
Article Type
Technical Solution

Product(s)

Environment

Issue



If 'SQLINSTANCE $ALL' is used to backup all instances in a clustered MS SQL Server, the backup will fail with status 2.


Solution



If 'SQLINSTANCE $ALL' is used to backup all instances in a clustered MS SQL Server, the backup will fail with status 2.
 
For example, if the batch script contains...
 
SQLINSTANCE $ALL
 
OPERATION BACKUP
 
DATABASE $ALL
 
SQLHOST "VSQL64.RASH.LOCAL"
 
NBSERVER "SLES-10.rash.local"
 
MAXTRANSFERSIZE 6
 
BLOCKSIZE 7
 
NUMBUFS 2
 
ENDOPER TRUE
 
VSQL64.RASH.LOCAL is the virtual name of MS SQL in VCS/MSCS cluster. It is currently active on host w2003-64-3.rash.local. There are two instances. One is the default instance, the second one is a named instance RASH1.
 

 
The dbclient log will show the following...
 

 
13:05:24.868 [1176.2888] <4> getServerName: Read server name from
 
nb_master_config: sles-10.rash.local
 
13:05:24.868 [1176.2888] <4> CDBIniParms::CDBIniParms: INF - NT User is SYSTEM
 
13:05:35.931 [1176.2888] <4> SQLEnumerator: INF - Enumerated SQL hosts:
 
SERVER:Server={(local),W2003-64-3,W2003-64-3\RASH1};UID:Login
 
ID=?;PWD:Password=?;Trusted_Connection:Use Integrated
 
Security=?;*APP:AppName=?;*WSID:WorkStation ID=?;
 
13:05:35.931 [1176.2888] <4> CGlobalInformation::SQLEnumerator: INF - Hosts and
 
instances retrieved from host list string
 
13:05:35.931 [1176.2888] <4> CGlobalInformation::SQLEnumerator: INF - host:
 
w2003-64-3
 
13:05:35.931 [1176.2888] <4> CGlobalInformation::SQLEnumerator: INF -
 
instance: <default>
 
13:05:35.931 [1176.2888] <4> CGlobalInformation::SQLEnumerator: INF -
 
instance: RASHEED1
 
13:05:35.931 [1176.2888] <2> CDBbackmain::UpdateBatchFileForAllInstances: DBG -
 
Instance not found for host vsql64.rash.local, trying batch SQLHOST
 
VSQL64.RASH.LOCAL
 
13:05:35.931 [1176.2888] <16> CDBbackmain::UpdateBatchFileForAllInstances: USER
 
- An instance of SQL Server was not found on this client.
 
13:05:35.947 [1176.2888] <4> CDBbackmain::dbbackup: INF - Results of executing
 
<C:\Program Files\Veritas\NetBackup\DbExt\Mssql\all.bch>:
 
<0> operations succeeded. <0> operations failed.
 
Solution:
 
Do not use 'SQLINSTANCE $ALL'. Create a seperate script for each virtual sql server name specifying it's correct instance name.  Each instance of sql requires a seperate virtual host name, virtual ip address and virtual drive.  This allows the sql instances to move independently between nodes.  A cluster requires the BROWSECLIENT statement in the script to properly assign the image to the virtual name of sql. 
 


Legacy ID



351499


Article URL http://www.symantec.com/docs/TECH129261


Terms of use for this information are found in Legal Notices