[ASManager] How to backup & restore SQL Database - 20260813

[support]

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.

2026-08-13_16h39_39.png (479.21 KiB) Viewed 153 times

4. Confirm the backup path, then click OK to complete the backup.

2026-08-13_16h39_51.png (313.08 KiB) Viewed 153 times

5. Follow the same procedure to back up ASLog, ASLPR, and ASPatrol.

2026-08-13_16h40_01.png (153.54 KiB) Viewed 153 times

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.

2026-08-13_16h40_18.png (518.05 KiB) Viewed 153 times

4. Add the path where the .bak file is stored according to the steps shown below, then click OK.

2026-08-13_16h40_29.png (435.64 KiB) Viewed 153 times

5. Verify that the .bak file path is correct, then click Options.

2026-08-13_16h40_49.png (390.91 KiB) Viewed 153 times

6. Select Overwrite the existing database, then click OK to confirm that the ASConfig database has been successfully restored.

2026-08-13_16h41_02.png (605.46 KiB) Viewed 153 times

7. Follow the same procedure to restore ASLog, ASLPR, and ASPatrol.