10-31-2019 03:49 AM
I have a question about the default SQL Server 2014 Express SP2 that is installed for the BEDB repository. It mentions in the Admin Guide that 10GB is the DB size limit. I'm wondering what kind of configuration would cause the DB to exceed 10GB? Is there some kind of guideline to this?
Also, can this database be used for other non-BE purposes? (I don't think we allow this).
Thanks.
Solved! Go to Solution.
11-01-2019 01:38 AM
Hello mk
I think the databases shouldn't be used for non-BE purposes. The setup of any version upgrade will change the database so no one can predict what the setup will do with the other databases.
I for myself had a problem with a job with lets grow the database to 8GB.
But normaly the database with pretty job number will not exced 500 MB. But it grows with the retension time of Job-Log, Alerts, number of servers, devices and media.
But normaly you would faster come to the limit of max RAM and CPU allocation of SQL Express than capacity. If this is the case a slowdown of Backup process is the case when running many jobs at same time. Then you will need the full SQL-Standard as Backup Exec database instance with BEDB Database in it.
Example Express Limit Version 2016: 1GB maximum memory used by the SQL Server Database Engine, The relational database engine is restricted to the lesser of 1 socket or 4 cores
Kind Regard
Lothar
11-01-2019 01:38 AM
Hello mk
I think the databases shouldn't be used for non-BE purposes. The setup of any version upgrade will change the database so no one can predict what the setup will do with the other databases.
I for myself had a problem with a job with lets grow the database to 8GB.
But normaly the database with pretty job number will not exced 500 MB. But it grows with the retension time of Job-Log, Alerts, number of servers, devices and media.
But normaly you would faster come to the limit of max RAM and CPU allocation of SQL Express than capacity. If this is the case a slowdown of Backup process is the case when running many jobs at same time. Then you will need the full SQL-Standard as Backup Exec database instance with BEDB Database in it.
Example Express Limit Version 2016: 1GB maximum memory used by the SQL Server Database Engine, The relational database engine is restricted to the lesser of 1 socket or 4 cores
Kind Regard
Lothar