Diff. of NAV Change Log Entry and SQL Log file

Silva

Hi,

Im using the NAV 5 sp1 and SQL Express Edition, and my database is closely to 4gb but when I check the Log File of SQL it has 13gb and my .MDF file is closely to 4gig. my question is why is the LOG FILE became 13gig,SQL express edition has limit of 4gb. Does it mean that it 4gb limit is compose only of .MDF? and another thing is the Change Log Entry of NAV is diffrnt from LOG file of SQL? Hoping for your reply.

Thanks

DenSter

They are two completely different things.

The change log in NAV logs modifications to tables and fields that are set up in the change log setup. So if you set up the Customer table to log the name field of the customer table, every time that a user modifies the name of a customer, the system writes a log entry into the change log.

The transaction log in SQL Server is an essential component of SQL Server, it cannot exist without it. I could write a lot of things about it, but the best thing is to check out Books Online (also known as BOL), which shuold be installed on your computer (start, all programs, SQL Server, documentation and tutorials). BOL is by far the best SQL Server resource. If you don't have it installed then you can also get to it online.

For SQL Server 2005: http://msdn.microsoft.com/en-us/library/ms130214(SQL.90).aspx
For SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms130214.aspx

Silva

Hi,

Thanks for the advise, I'll check on that. Thanks for the support.

DenSter

You're welcome