02-03-2020 02:35 AM - edited 02-24-2020 10:51 PM
Hi,
We have two SQL servers mirrored. There is one DB used by both the servers.
Now if I have to backup the database how should I proceed? Both the clients will be involved or only one (what I think)?
Overall how does this work?
Thanks.
02-03-2020 03:01 AM
Hello,
have you gone through NetBackup SQL Admin Guide? It is documented there.
What is your SQL Server version? NetBackup 7.6 is old and behind EOL, maybe you don't have a supported combination.
Regards
Michal
02-03-2020 03:05 AM
Do you perhaps mean clustered?
Regular failover cluster or AlwaysOn Availability Groups?
Are you aware of the fact that support for NBU 7.6 ended some years ago?
I am not sure that any compatibility lists for 7.6 are still available on Veritas web site - I have attached the last DB SCL that I have (dated June 2016).
Current compatibility lists can be found here: http://www.veritas.com/docs/000033647
To get back to your question - failover clustered SQL database backup is done by using the Virtual hostname for the clustered SQL instance. This will backup the database(s) on the active node.
Steps to backup clustered SQL database is covered in NBU for SQL Admin Guide.
Be sure to work with the SQL DBA to configure SQL database backups.
(Links to manuals can be found in Handy NBU links in my signature.)