Database over 200GB

Hi,

Does any one maintain or have a Sage 300 ERP running under MS Sql for size over 200GB? Any issue? And have you ever done dbdump , dbload ? How long normally it takes for dbdump and dbload? Thanks

Parents Reply
  • in reply to microtek

    Dump/load will not fix anything, you will be wasting your time. Look at your SQL server resources, you will need a lot of RAM (64GB+) and CPU to manage that size db. Your SQL server will have to be dedicated to SQL only, nothing else running on that server.

Children