You have an Identify deployment that uses SQL cluster.
Note: remember to back your databases up before proceeding.
Move database files to another location
In this example, we choose to move files of the IdentifyAudit database to
D:\data. Firstly, verify the current data files path using command:
- Primary Replica data file locations
- Secondary Replica data file locations
Step 1: Suspend data movement
Connect to the Secondary replica and go to Always on High Availability. Expand the High Availability and right-click on the database and choose Suspend Data Movement.
The Suspend Data Movement wizard opens, click OK button
Once it is completed, you can see its Pause status
Step 2: Remove secondary database
In this step, you must remove the database out of the Always on Availability Group of the secondary replica. Right-click on the database and choose Remove Secondary Database.
After the wizard below opens, click OK
Once it is done, you can see the new status of the IdentifyAudit database:
Step 3: Stop SQL service
Stop the SQL Service on the secondary replica using the SQL Server Configuration Manager.
Step 4: Move data files to the new location
Move database files to the new location and start the SQL Service again.
Step 5: Tell SQLServer that you want to move files to a new location
ALTER DATABASE IdentifyAudit
MODIFY FILE ( NAME = IdentifyAudit,
FILENAME = 'D:\data\IdentifyAudit.mdf');
Step 6: Join it to Availability group
On the secondary replica, right-click on the database and choose Join to Availability Group.
Step 7: Promote the secondary replica to be the primary replica
After this step is done, the previous primary replica has become the new secondary replica.
Step 8: Repeat the 1st step to 7th step on new secondary replica
Repeat Step 1 to Step 7 on the new secondary replica. After that, you can switch their roles back if you want to.
After moving the IdentifyAudit database's data files, you can verify that everything works well:
- Access an Identify instance and perform a login to its Admin site.
- Use the Identify Configurator to create/upgrade/remove/replicate an instance.