[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

File replication in workgroup environment

Posted on 2004-11-16
6
Medium Priority
?
602 Views
Last Modified: 2012-08-13
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
0
Comment
Question by:rjayres
  • 4
  • 2
6 Comments
 
LVL 11

Expert Comment

by:WeHe
ID: 12597834
if a sheduled mirroring meets your needs, use ROBOCOPY for a simple mirroring.
0
 
LVL 1

Author Comment

by:rjayres
ID: 12598008
Mirroring must be real-time, even running robocopy /mir every 5 minutes won't do it, as immediately the file is placed it must be accesible to both IIS Servers.
0
 
LVL 11

Expert Comment

by:WeHe
ID: 12598424
then create a DFS. that should do this.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
LVL 1

Author Comment

by:rjayres
ID: 12605159
I thought that DFS in a workgroup did not support replication, how do I set it up so that it does?
0
 
LVL 11

Expert Comment

by:WeHe
ID: 12605189
just set up a standalone DFS with 2 or more Root Targets.
if DFS sees more then 1 Target, it will try to replicate 3 seconds after a file has changed.
0
 
LVL 11

Accepted Solution

by:
WeHe earned 2000 total points
ID: 12638784
to complete the info:

you have to activate FRS manually after creating the DFS (In Properties of the Root Targets).
it's disabled by default.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question