File replication in workgroup environment
Posted on 2004-11-16
I have 4 servers setup in the following configuration..
All running Windows 2003
Webserver 1 and Webserver 2 running network load balanced IIS 6 with an ASP.net application that talks to SQL Server 1 and SQL Server 2 in a cluster.
The webserver has an interface that allows users to add information to the Database, and also upload files associated with this data.. the application keeps track of where the file is saved (on a drive on the SQL servers).
What I want to do is have the files saved to either one of the SQL servers and replicated back, so any failure of one SQL server will not lose acces to the files for the web applications on the IIS servers.
The servers are all running in a workgroup with no DC