Move LDF, MDF or NDF file in SQL Server 2016 using Alter Database

In my previous post I explained how to move a certain database file with ATTACH/DETACH. There is another betterĀ option which I would like to share with you.: Let’s say you need to move the NDF file. The first thing to do is to alter the database. Specify the new path of the NDF file like… Read More Move LDF, MDF or NDF file in SQL Server 2016 using Alter Database

Move LDF, MDF or NDF file in SQL Server 2016 using Attach/Detach

As a DBA or even NAV Admin this topic is very important. In my other post (Physical Database Structure of a Dynamics NAV SQL database) I explained database files and their file extensions. Let’s say you need to move the logfile because of certain reasons like diskspace. The first thing to do is to Detach… Read More Move LDF, MDF or NDF file in SQL Server 2016 using Attach/Detach

Object Metadata Table (C/AL translated into C#)

Before you can run or execute a Microsoft Dynamics NAV object (Codeunit for example), you must compile the object. By Compiling the object your C/AL code will be transformed into C# Code. NAV only runs compiled C/AL code which is transformed into C# Code. This code is stored in table ‘2000000071 – Object Metadata’ To… Read More Object Metadata Table (C/AL translated into C#)