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 Children
  • in reply to kkyle1

    Dear All,

    Thanks for the input. Basically the dump load is not use for backup. But found out some unsual things going on in the accpac like slower day end, or not responding. Also some other posting issue in modules. So would think to consider doing dump/load to get a refresh.

    Did test to dump/load for several times, and it always get stuck on a different tables. Dont know why still trying to figure out the issue.

  • 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.

  • in reply to Ettienne Schwagele

    you might also check drive space where your data, logs and tempdb files reside ..

  • in reply to Scott Schreiner

    Hi,

    Just to update on the status of this database, I managed to rescue the db but only by creating a new sql database with a different name and then do a dbload onto it and now it is working fine. Customer using the SSD Disk , the loading took about 1 day time to process. Thanks for all the input and comment