Creating a new database

Creating a new database is not a day-to-day activity, but knowing about it will be an advantage. In this recipe, we will create a new NAV database and take a look at a few very important settings.

How to do it...

1. Open Microsoft Dynamics NAV 2013 Development Environment.

2. Go to File | Database | New and provide your SQL server details and logon credentials. You will be presented with a New Database screen.

   

3. Provide the Server Name and Database Name. The database name needs to be unique among all the databases of that server.

4. Next, go to the Database Files tab and modify the default value of the File Name column to save the data file on the non-system drive.

   

5. From the same tab, uncheck the column value of Unrestricted Growth and provide a Maximum Size value, as shown in the previous screenshot.

6. As you did previously, update the Transaction Log File tab.

   

7. Next, open the Options tab and change Recovery model..... to Simple.

   

8. Finally, from the Integration tab, select the Save license...