My customer wants us to be able to refresh our Geodatabase during the day without brining our Applications down. So this needs to be a HOT refresh. In the past I have been doing a nightly one time refresh via backup and restore with SQL Server Jobs, but since the databases are getting large that is no longer acceptable, it takes down our site and creates a lag for the customer data of at least 1 day.
I started working with Log Shipping but found that since ArcIMS and ArcGIS Server can't use the database in a warm standby mode that this won't work.
I haven't looked at any other method of doing this type of refresh, like replication or db mirroring, so I was wondering if someone else has already tackled this challenge?
Thanks,
Joe
