Microsoft Dynamics AX 2012 Backup Restore

Back up a database

1. Login to database server
2. Open SQL Server Management Studio
3. Select Server type = Database engine
4. Select Server name = << YOUR DATABASE SERVER NAME >>
5. Select Authentication = << YOUR DATABASE AUTHENTICATION >>
6. Click Connect
7. Expanded Database
8. Select Database name to backup
9. Right-click database -> Tasks -> Back up…
10. Verify database in dialog
11. Select backup type = Full
12. Select Backup component = Database
13. Select Back up to = Disk
14. Confirm target file path
15. Click OK to backup

Restore database

1. Login to database server
2. Open SQL Server Management Studio
3. Select Server type = Database engine
4. Select Server name = << YOUR DATABASE SERVER NAME >>
5. Select Authentication = << YOUR DATABASE AUTHENTICATION >>
6. Click Connect
7. Right click databases -> Restore File and Filegroups
8. Enter To database
9. Select From device and click add to add file
10. Tick Restore at grid
11. Go to option tab
12. Tick overwrite the existing database
13. Check restore as folder and file name
14. Click OK to restore