SQL Server log size

billtadpole
billtadpole Member Posts: 2
edited 2005-01-31 in NAV/Navision Classic Client
Hi,

Is it normal for Navision to produce SQL Server logs of 11 gigabytes in an hour?

My client is an exporter who typically scans the barcodes of 200,000 items in an hour. That works out at about 55 kilobytes of log per item. My background is SQL Server (not Navision). To me, 55KB per item seems a lot.

Any comments gratefully received.

Bill

Comments

  • jsoage
    jsoage Member Posts: 9
    have a look a this

    http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=8691

    hope this helps.
  • GoMaD
    GoMaD Member Posts: 313
    In your SQL enterprise manager you should check the recovery model of your database (database->properties->Options Tab).

    If you use 'Simple' or 'Bulk-Logged' the Log file with not grow in such a rapid way.

    BUT, of course this has some drawbacks in the backup/restore department

    #-o
    Now, let's see what we can see.
    ...
    Everybody on-line.
    ...
    Looking good!

Categories