VESQL database restore to Always On Availability Groups with automatic seeding enabled is hanging

KB ID: 2375
Product:
Version: 8.x, 9.x
Published:
Last Modified: 2017-11-08

Challenge

VESQL database restore to Always ON Availability Group with automatic seeding enabled (SQL 2016 SP1 and later) does not work. Veeam SQL Explorer log shows repeating records like:

10/23/2017 8:19:22 PM   11 (5160) SQL query: ALTER DATABASE [<database-name>] SET HADR AVAILABILITY GROUP = [<group-name>]
10/23/2017 8:19:32 PM   11 (5160)     Adding database to Availability Group '<group-name>'...
10/23/2017 8:19:32 PM   11 (5160) SQL query: ALTER DATABASE [<database-name>] SET HADR AVAILABILITY GROUP = [<group-name>]
10/23/2017 8:19:42 PM   11 (5160)     Adding database to Availability Group '<group-name>'...
10/23/2017 8:19:42 PM   11 (5160) SQL query: ALTER DATABASE [<database-name>] SET HADR AVAILABILITY GROUP = [<group-name>]
10/23/2017 8:19:52 PM   11 (5160)     Adding database to Availability Group '<group-name>'...

 

Cause

Restore to Always ON Availability Group with automatic seeding is not supported by current version of Veeam.

Solution

Manually stop automatic seeding prior to performing restore as described here.

How helpful is this article: 
5 out of 5 based on 7 ratings

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.

Request new content

Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Orphus system