topic MSSQL vs. MYSQL and Backup in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/mssql-vs-mysql-and-backup/m-p/80267#M53571 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am planing on installaing Alfresco on a server for it self. I do allready have a nice fast MSSQL server but i am not sure if its better to just install the MYSQL server on the server that Alfresco will run from.</SPAN><BR /><BR /><SPAN>Resons i am thinking about is what way would be best regarding backup of Alfresco and disaster recovery.</SPAN><BR /><BR /><SPAN>How big will the SQL database grow, will it be over 2GB with around 1 mill. files?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Thu, 19 Jul 2007 09:25:19 GMT unknown-user 2007-07-19T09:25:19Z MSSQL vs. MYSQL and Backup https://connect.hyland.com/t5/alfresco-archive/mssql-vs-mysql-and-backup/m-p/80267#M53571 Hi,I am planing on installaing Alfresco on a server for it self. I do allready have a nice fast MSSQL server but i am not sure if its better to just install the MYSQL server on the server that Alfresco will run from.Resons i am thinking about is what way would be best regarding backup of Alfresco an Thu, 19 Jul 2007 09:25:19 GMT https://connect.hyland.com/t5/alfresco-archive/mssql-vs-mysql-and-backup/m-p/80267#M53571 unknown-user 2007-07-19T09:25:19Z Re: MSSQL vs. MYSQL and Backup https://connect.hyland.com/t5/alfresco-archive/mssql-vs-mysql-and-backup/m-p/80268#M53572 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><A href="http://forums.alfresco.com/viewtopic.php?t=873" rel="nofollow noopener noreferrer">http://forums.alfresco.com/viewtopic.php?t=873</A><BR /><SPAN>As I say in that post, the best is to take a sample set of documents and load the server up a bit to see.&nbsp; I'm pretty sure that 2GB will be passed before 1 million documents, especially if you have versioning, etc.&nbsp; That being said, we'll be refactoring some of the DB schema to reduce the size quite significantly in an upcoming release.</SPAN><BR /><BR /><SPAN>Having the DB on the same machine as the server is obviously not ideal for performance.&nbsp; I wouldn't say it was better to have it that way.&nbsp; If you're confortable with MSSQL, then use it.</SPAN><BR /><BR /><SPAN>Regards</SPAN></BODY></HTML> Wed, 25 Jul 2007 05:20:04 GMT https://connect.hyland.com/t5/alfresco-archive/mssql-vs-mysql-and-backup/m-p/80268#M53572 derek 2007-07-25T05:20:04Z