Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

SQL DATABASE BACKUP FAILING AFTER FAILOVER

Created: 04 Nov 2012 • Updated: 05 Dec 2012 | 13 comments
This issue has been solved. See solution.

HI Experts,

 

We have a SQL cluster and as i know that if failover happens to another DB server the backup will fail as the netbackup cannot find the path of the files to be backedup , Is this true ??

Ex:- If i have DB01 and DB02 , if DB01 is failed over to DB02 then backup of DB01 fails with the error 71 (None of the  files in the file list exist) ??

Please advise on this and provide a solution for this if i can still take a  backup if the DRIVES are FAILED OVER to another DB server.

 

Thanks,

Nayab

Comments 13 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

Did you configured SQL backup with node name?
Why don't you configure with virtual host name?

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Nayab.Rasool's picture

Node name in the sense how it should be given i mean let me tell how it is in my environment 

It is a Five Node Cluster DB01 ...DB05 on WINDOWS 2008 and all the HOST name will be like INDB01,2,3,4, 

If i configure virtual host name will the backup happen in the case of failover as well ?? If yes how to do it please advise 

 

Thanks,

Nayab

Nayab.Rasool's picture

ALL SERVERS ARE PHYSICAL WINDOWS 2008 R2 

Netbackup Version :- 7.1 On all Master , media , clients

 

Marianne's picture

We normally create 2 policies for clusters:

1. Policy for physical nodenames to backup local drives, e.g.
C:\
Shadow Copy Components

2. Policy for Virtual hostname to backup shared/cluster data.
This can be a application/database policy type to backup database online or MS-Windows policy to backup database dumps. 
For a FileShare cluster, this policy will be the drive letters for shared data.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Nayab.Rasool's picture

All our machines are PHYSICAL ones so the first point applies here now please let me know wat information i have to provide for u to check and make the backup happen when it was failed over to other SERVER ??

 

Yasuhisa Ishikawa's picture

Please have a look on Chapter 7 "Using NetBackup for SQL Server with clustering solutions" in NetBackup 7.1 for Microsoft SQL Server Administrator's Guide.
http://www.symantec.com/docs/DOC3670

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Marianne's picture

All our machines are PHYSICAL ....

Please speak to your Cluster Admins to explain the concept of Virtual hostname and Virtual IP.
This is how users and other applications are connecting to SQL.

The whole point of a cluster is to be able to connect to the database/application regardless of which physical nodename the cluster is active on.
This is where a Virtual IP and hostname is used. It fails over along with drive letters and SQL services.

Please get this virtual hostname and IP address from Cluster Admins.
Ensure forward and reverse lookup between master and media server(s) and the virtual hostname and IP.

Create a separate policy as per no. 2 in my post above.

 

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Nayab.Rasool's picture

Hello Maria,

 

I have checked with my CLUSTER ADMIN he gave me one IP ADDRESS and HOSTNAME and said this is our CLUSTER IP and HOSTNAME ( VIRTUAL ) , please advise me how to proceed on this do i need to create a new policy for this else i can add this IP to existing policies as we have 4 Policies for DB backups like Filesystem , FULL , LOG , etcc.... Please Advise.

 

Thanks,

Nayab

Marianne's picture

It all depends on what exactly is in policies.

If Filesystem is for local drives only (e.g. C:\ and SCC) then one policy for the physical nodenames.

All policies that are backing up SQL data must be changed to Virtual hostname.
If you are using the SQL agent, you need to update the script(s) as well.

See the section in NBU for SQL Admin Guide as per Yasuhisa's post.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

jim dalton's picture

In simple terms, your physical boxes (nodes) will probably have one or more static addresses, they never change regardless of the state of your cluster and then your sql instances will each have floating addresses and these can relocate from one physical box to another as the state of the cluster changes.

Hence to backup an instance you use the instance address in the policy which will exist on a node...you dont know which node at the time of backup and you dont need to know: the floating address is part of the cluster framework and is managed by it.

So as per MvdB and others: to backup your OS: use the node addresses: the physical addresses of the machines in the (windows) policy; to backup the sql instances use the floating addresses in the (sql) policy (or virtual addresses as other have called them) and associated bch file. 

jim

SOLUTION
Nayab.Rasool's picture

Will i be able to Use the CROSS MOUNT BACKUP to have the drives backed up when it actually fails over to other DB server ...may i know hw it works and also if any impact.

Yasuhisa Ishikawa's picture

Why do you consider "CROSS MOUNT BACKUP"? did you mean 'cross mount point'?

Golden rules for cluster backup is:
* Backup disks and applications under control of cluster should be backed up by cluster host name.
* Backup disks and applications out of cluster control should be backed up by node host name.
* Should not mix resources to be backed up under cluster control and out of cluster control into single backup. if do do, you need to be aware of which node the service is online on at backup and at restore.

I recommend you to create at leadt two policies for file backup(uh, this is beyond the scope of first post; you start this thread wiyh MSSQL backup) - one for shared disks under cluster control, and another for local disks.
You don't have to and should not to enable cross mount point unless you understand concept of cluster backup well, you can completely trace which host the service have been online on, and you never feel pain to manage backup and restore with node host name.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan