SQL SERVER 2012 Database for Dynamics Nav 2013 Transaction Logfile **.ldf

Business Central/NAV Technical Forum
1

Hi

SQL SERVER 2012 Database for Dynamics Nav 2013 Transaction Logfile **.ldf grows up to 228 GB on my server, please advise how do I shrink it.

2

Welcome to DUG!!!

Look at the following link

http://msdn.microsoft.com/en-us//library/ms189493.aspx

http://technet.microsoft.com/en-us/library/ms189493(v=sql.105).aspx

3

What’s your DB’s Recovery Model? How often do you run TLog Backups?

4

Hi Jorg,

Our recovery model is Full,

5

Thanks,

But would the empty file affect the database of my NAV when i do recovery? and will the migrated files be just as huge?

6

A DBCC SHRINKFILE won’t resolve your problem. You need to set up periodic Transaction Log backups, e.g. every hour.
This probably would fulfil your requirements regarding “data-security” and keeping the log-file-size reasonable.

Once you have implemented a sufficient backup-cycle, the ou coould SHRINK the file down to a reasonable size (i.g. 20% of net db-size)