Data Backup and Recovery

SnapCenter and SQL AvailabilityGroup

sanderbreur
2,876 Views

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

Sahana
2,826 Views

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.

neerajd
2,717 Views

hi 

 

 

 

 

 

 

 

 

Public