I have two Compaq 1600 with Imations MediaManager Databases. i would like to mirror or replicate thses databases for redundancy purposes, as well as, have my group hiting one of the sql servers and the rest of my company hitting the other for performance reasons. The two servers will be linked with a crossover fibre cable for there own private Lan. What is out there that is available to do this without affecting the current server too much?
SQL server will not allow you to mirror it on the network, what you would be able to do is configure replication so that your data is always available to all the users. If you use MS Dstributed Transaction
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.