SQL Server backups in a Cluster
Good morning.
Running SQL Server 2008 R2 in a MS 2 Node Server Cluster.
My setup is as follows:
Cluster Name: KOCSQLC02D
Physical Server (Node1): KOCWSQL03D
Physical Server (Node2): KOCWSQL04D
SQL Server Default Instance: KOCSQL02DDI
SQL Server Named Instance: KOCSQL02DI1\AML
I am trying to backup both SQL Server Instances using Netbackup 7.5
We have an admin server and I am running the NetBackup 7.5 (with the SQL agent) on both physical nodes of my Cluster
Our Backup Admin has set up one Policy for both SQL instances. the policy name is: Onsite_Supreme_SQL-Cluster_Database
I have identical scripts on both phyical nodes of the cluster in this folder: C:\Program Files\Veritas\NetBackup\DbExt\MsSql
I also logged in directly to both of the phyical Servers in the Cluster and configured the Server connection settings for both SQL Server Instances.
With the Cluster Resources owned by Node 1 of the Cluster - the backups run fine.
When I fail the Cluster Resources over to Node 2 of the Cluster - I get the following error:
OPERATION BACKUP
DATABASE "Admin"
SQLHOST "KOCSQL02DI1"
SQLINSTANCE "AML"
NBSERVER "KOCBKUP02"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY Onsite_Supreme_SQL-Cluster_Database
BROWSECLIENT "KOCSQLC02D"
NUMBUFS 2
ENDOPER TRUE
DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.>.
ERR - Unable to login into SQL instance <KOCSQL02DI1\AML> as user <sa> using standard connection.
ERR - Internal error. See the dbclient log for more information.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\KOCSQL02DI1_Full_Backups.bch>:
<0> operations succeeded. <3> operations failed.
INF - The following object(s) were not backed up successfully.
INF - Admin
Can anyone tell me what I might be doing wrong?
Comments 4 Comments • Jump to latest comment
You need just a single SQL backup policy that points to the virtual name of the SQL instance. I no longer have a cluster, but here is how it was set up.
Server 1 was named cero-clus-01
Server 2 was named cero-clus-02
Virtual name for SQL instance was CERO-VSQL-01
I had identical backup BCH files on each node that referenced the virtual SQL name. That way, no matter what node was the owner, the SQL backup completed.
Aside from the fact that we have more than one policy for the SQL Cluster - I think my set up the same
I have identical BCH file on each node of the cluster and they both reference the virtual Cluster Name
My set up is this:
Cluster Name KOCSQLC02D
Server 1 KOCWSQL03D
Server 2 KOCWSQL04D
Virtual name for SQL instance Default Instance KOCSQL02DDI
Virtual name for SQL instance Default Instance KOCSQL02DI1\AML
and here is a sample of one of my scripts:
OPERATION BACKUP
DATABASE "Admin"
SQLHOST "KOCSQL02DI1"
SQLINSTANCE "AML"
NBSERVER "KOCBKUP02"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY Onsite_Supreme_SQL-Cluster_Database
BROWSECLIENT "KOCSQLC02D"
NUMBUFS 2
ENDOPER TRUE
This script ONLY works if I have the cluster resrouces on the KOCWSQL03D node eventhough I am NOT specifying KOCWSQL03D or KOCWSQL04D in my script- i am specifying the Cluster name instead.
confused!
You dont specify the cluster name, you specify the virtual SQL server name. These are 2 seperate attributes with distinct IP addresses.
Browseclient should be the virtual SQL instance
Do you have 2 instances on the same cluster? If so, they should have 2 virtuial names and ip addresses
I think that is wh I'm so confusedat to why it is working when my Cluster Resources are owned by node1 and not node 2
I do have 2 SQL Server Instances, they are 2 seperate attributes each with it's own set of Disks and it's own IP address.
the overall Virtual Cluster Name is KOCSQLC02D (IP address xxx.16.5.2)
SQL Instance 1 (Default Instance) is called KOCSQL02DDI (IP address xxx.16.5.3)
SQL Instance 1 (Named Instance) is called KOCSQL02DI1 (IP address xxx.16.5.4)
Here are samples of my scripts - one for database called ADMIN in the KOCSQL02DDI Instance and one for a database called ADMIN inthe KOCSQL02DI1\AML instance:
OPERATION BACKUP
DATABASE "Admin"
SQLHOST "KOCSQL02DDI"
NBSERVER "KOCBKUP02"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY Onsite_Supreme_SQL-Cluster_Database
BROWSECLIENT "KOCSQLC02D"
NUMBUFS 2
ENDOPER TRUE
******************************************
OPERATION BACKUP
DATABASE "Admin"
SQLHOST "KOCSQL02DI1"
SQLINSTANCE "AML"
NBSERVER "KOCBKUP02"
MAXTRANSFERSIZE 6
BLOCKSIZE 7
POLICY Onsite_Supreme_SQL-Cluster_Database
BROWSECLIENT "KOCSQLC02D"
NUMBUFS 2
ENDOPER TRUE
Would you like to reply?
Login or Register to post your comment.