Data Backup and Recovery Discussions

SnapCenter and SQL AvailabilityGroup

sanderbreur

Hi,

 

during install of SnapCenter 1.1 youve got the option "install local SQL express DB or use an existing SQL server/instance.

We have an SQL Availability Group (AG) so we chose the second option for a existing host.

 

Now, if we use the AG name with windows credentials install fails with error 1603 in the log.

If we do the same but use a nodename/instance of the same AG install finishes fine and DB is added to the node.

However, this is nog the way we want it because with a AG host failover DB's become stale.

 

So, is there a workaround to use the AG name during install?

2 REPLIES 2

Re: SnapCenter and SQL AvailabilityGroup

Sahana

Hi,

 

Try using the cmdlet Add-SmBackupDataset  Refer https://library.netapp.com/ecm/ecm_get_file/ECMLP2440057 

 

Refer page 8 Resources: For availability group backup @{"Host"="localhost";"Type"="SQL Availability Group";"Names"="AG1"} Valid Type values are: SQL Database, SQL Instance, SQL Availability Group. You can include comma-separated values for Names. 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

Re: SnapCenter and SQL AvailabilityGroup

neerajd

hi 

 

 

 

 

 

 

 

 

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums
Public