We want to use published database for ArcGIS Server Map services for performance reason. These Map services will be used by application where user can view the data no write access.
1. What type of database should we use file or SQL read only
2. What is type of database replication available in ArcGIS server that we can run as overnight process to transfer data from Production to publish database