GV FAE Knowledge

SQL Backup
1. Open ASDBManager and disconnect the SQL database from ASManager.
2. Download and run SQL Server Management Studio (SSMS): https://learn.microsoft.com/en-us/ssms/install/install (Download the SSMS 22 installer)
3. Right-click ASConfig and select Tasks → Backup. 4. Confirm the backup path, then click OK to complete the backup. 5. Follow the same procedure to back up ASLog, ASLPR, and ASPatrol. Once all backups are completed, copy the following four .bak files to the new PC environment.

SQL Restore
1. Open ASDBManager and disconnect the SQL database from ASManager.
(You can use ASDBManager to create a new SQL database in advance if necessary.)
2. Open SQL Server Management Studio.
3. Right-click ASConfig and select Tasks → Restore → Database. 4. Add the path where the .bak file is stored according to the steps shown below, then click OK. 5. Verify that the .bak file path is correct, then click Options. 6. Select Overwrite the existing database, then click OK to confirm that the ASConfig database has been successfully restored. 7. Follow the same procedure to restore ASLog, ASLPR, and ASPatrol.