Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

SQL Database is getting full

SOLVED

Posted By selvakannanking2 over 5 years ago

Hi,

Our SAGE is getting error and we found the issue is from SQL server database full. Though our transactions are not heavy, our database is getting full every week. It seems the SQL log is growing a lot and making an issue. Any suggestion?

Top Replies

Terry_G over 5 years ago +1 verified

Set recovery model to "Simple"

+1 Terry_G over 5 years ago

verified answer

Set recovery model to "Simple"
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel
0 SergeB over 5 years ago in reply to Terry_G

Before doing that, what are your DB recovery expectations? If you want to restore to a specific point in time, then you need Full Recovery. The trade-off with Full is you need to manage those logs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

SQL Database is getting full

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING