SQL Server requirements - Vault 2015 ADMS - AVFS

[egil.sporild]

Hello everyone.

Does anyone know if it's required to have full SQL server installed when running an replicated environment consisting of for example one Vault 2015 ADMS / SQL server with one or more connected AVFS?

Or is SQL Server express sufficient since we're running only one SQL Server?

Thanks in advance.

[DarrenP]

SQL express does not do any replication as far as i know

edit: i take that back it looks it does do some replication according to this

http://msdn.microsoft.com/en-us/library/cc645993.aspx

[egil.sporild]

Yes, I know that. But is replication functionality really required when you have only one SQL server?

Thanks

[Neil_Cross · Accepted solution]

No, you won't need Full SQL Standard or Enterprise if running AVFS, Express should be fine.  

If you only have one Vault SQL Database, and the other sites are filestore only, there is no need for SQL publisher & subscriber replication therefore you won't need full SQL.  All traffic between sites will be handled by the AVFS and ADMS.  You'll be fine with Express.

Replication functionality is not required, this is referring to the 'Workgroup Replication' options that you'll see in the ADMS.

[ihayesjr]

While Neil is correct, you need to consider the performance of SQL Express in such a large environment.  If you have more than 1 AVFS, SQL Express may not perform well.  You need to take that into consideration for your environment.