Skip to content

Latest commit

 

History

History
33 lines (24 loc) · 1.71 KB

task_reseed_availability_group_databases.adoc

File metadata and controls

33 lines (24 loc) · 1.71 KB
Raw
permalink sidebar keywords summary
protect-scsql/task_reseed_availability_group_databases.html
sidebar
Reseed is an option to restore Availability Group \(AG\) databases. If a secondary database gets out of synchronization with the primary database in an AG, you can reseed the secondary database.

Reseed Availability Group databases

Reseed is an option to restore Availability Group (AG) databases. If a secondary database gets out of synchronization with the primary database in an AG, you can reseed the secondary database.

What you will need

  • You must have created backup of secondary AG database that you want to restore.

  • The SnapCenter Server and the plug-in host must have the same SnapCenter version installed.

About this task

  • You cannot perform reseed operation on primary databases.

  • You cannot perform a reseed operation if the replica database is removed from the availability group. When the replica is removed, the reseed operation fails.

  • While running the reseed operation on SQL Availability Group database, you should not trigger log backups on the replica databases of that availability group database. If you trigger log backups during reseed operation, the reseed operation fails with The mirror database, "database_name" has insufficient transaction log data to preserve the log backup chain of the principal database error message.

Steps

  1. In the left navigation pane, click Resources, and then select SnapCenter Plug-in for SQL Server from the list.

  2. In the Resources page, select Database from the View list.

  3. Select secondary AG database from the list.

  4. Click Reseed.

  5. Monitor the operation progress by clicking Monitor > Jobs.