DB restore in AX(.bak file).

Follow the below steps.

1.Stop the Ax services.

1. MS Batch
2. MS Data import.
3. World wide.
4. Management reporter.

2. Close the Visual studio. 

3. Open SSMS with the admin.

4. Right-click on databases and select Restore Database.

5. Select Device and select the path of the file and assign a name to the Database.

6. Click on add and select file.

7. Remove check of tail-log back up and check the close existing connections.

8.Start the services, open VS, and set full sync.

For the .bacpac file Please Click here.

Keep Daxing!!

Change Data base name in SQL through query.

USE master

GO

ALTER DATABASE AXDB

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

GO

EXEC master..sp_renamedb 'AXDB','AXDB_Old'

GO

ALTER DATABASE AXDB_Old

SET MULTI_USER

GO

Keep daxing!!