Taking backup of the databases to the Active server alone

Question

Taking backup of the databases to the Active server alone

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
November 1, 2016 at 6:36 am

#331843

Comments posted to this topic are about the item Taking backup of the databases to the Active server alone
Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

christoffersen366 Old Hand Points: 373 More actions · Answer 1

From SQL Server 2014 onward you can use "sys.fn_hadr_is_primary_replica" instead to determine if the current server is primary.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

christoffersen366 (11/8/2016)
From SQL Server 2014 onward you can use "sys.fn_hadr_is_primary_replica" instead to determine if the current server is primary.

Thanks for the tip.