Restore the master database in Analytics Platform System (APS)
The Restore Master page of the SQL Server PDW Configuration Manager enables you to restore the master database from a backup.
Before you begin
Important
To perform the restore, SQL Server PDW must delete the current master database, which contains user security information and the database catalog. We recommend making a backup of the current master database before performing the restore.
Restore the master database
Launch the Configuration Manager. For more information, see Launch the Configuration Manager (Analytics Platform System).
In the left pane of the Configuration Manager, select Restore Master.
Select the master backup to restore.
Select Apply.
To perform the restore, SQL Server PDW will shut down all appliance services and disconnect all users. After the restore completes, SQL Server PDW will restart the appliance services.
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for