How to create a New Database in Dynamics 365 BC, Business Central

Create a New Database in Dynamics 365 BC:

STEP-01: 

• Download SQL edition from the below link.
• https://www.microsoft.com/en-us/sql-server/sql-server-downloads

STEP-02:

• Install SQL.
• There are three SQL Server Edition available- Express, Standard, and Enterprise.
• You can select SQL Server Edition as per your requirement of the business.
• In this installation guide, I have installed the SQL Express edition of Basic type.
• In SQL Express edition, only a 10GB database is available.

STEP-03:

• After SQL installation, Open SQL Server Management Studio as shown below.

STEP-04:

• After that Select Server Name and press Connect button.

STEP-05:

• Now Right-click on Database and select option Restore Files and FilesGroup.

STEP-06:

• After you click on Restore Files and FilesGroups, a new window will open.

STEP-07:

• After that enter the name of the Database in To database field and select option From Device and press Assist button, as shown below.

Note: .bak file path in D365 BC setup

“Dynamics.365.BC.12076.W1.DVD\SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\160\Database”

STEP-08:

• After the above step, press on Add button.

STEP-09:

• Select .bak file from the path.
• After it is selected, then press OK.

STEP-10:

• Select Restore button and press OK.

STEP-11:

• MyNewDatabse has been created with Cronous Database.

STEP-12:

• Open Business Central Administration.
• Right-click on it and Run as administrator.

STEP-13:

• Select the instance and enter the Database Name.

Also Check Out: How to create a New Instance in Dynamics 365 BC, Business Central

STEP-13:

• After the above step. Restart the services.

STEP-14:

• Open Microsoft Dynamics 365 Business Central in the browser.
• By default, CRONUS Company opens now using the below link for creating blank new companies in Business Central.

Click Here: How to Create New Companies in Dynamics 365 Business Central