Technology

How to shrink a Navision DB Log file in a SQL 2008 Server

Premanath Kumarage · Author
1 min read
A smartphone and laptop side by side displaying data dashboards

alter database "Demo Database NAV (6-0)" set recovery simple go checkpoint go alter database "Demo Database NAV (6-0)" set recovery full go dbcc shrinkfile ("Demo Database NAV (6-0)_Log" , 1) go

alter database "Demo Database NAV (6-0)" set recovery simple

go

checkpoint

go

alter database "Demo Database NAV (6-0)" set recovery full

go

dbcc shrinkfile ("Demo Database NAV (6-0)_Log" , 1)

go

Written by

Premanath Kumarage

Author

All insights →

Start here

Every piece here started as a client problem. Tell us yours.

A working session, not a sales call. Bring the process your current system fights you on, and we will tell you plainly what it would take to fix it.

Newsletter

One email a month. No filler.

Stay ahead with Microsoft Business Applications.
Insights, implementation advice and practical ideas to help your business get more from Microsoft technology.

By subscribing, you acknowledge MicroCloud 360’s Privacy Policy.