Solved

Replicating or mirroring SQL Database

Posted on 1998-10-06
5
335 Views
Last Modified: 2010-03-19
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?
0
Comment
Question by:brianbarden
  • 2
  • 2
5 Comments
 
LVL 7

Expert Comment

by:spiridonov
ID: 1090416
You can setup replication without use of any additional tools. SQL Server has this functionality by itself.
0
 

Author Comment

by:brianbarden
ID: 1090417
Also give me redundancy and Failover capabilities.
0
 

Author Comment

by:brianbarden
ID: 1090418
Also give me redundancy and Failover capabilities.
0
 
LVL 7

Expert Comment

by:spiridonov
ID: 1090419
There is mirroring option in SQL server itself, butdue to performace issues I would suggest  to use RAID.
0
 

Accepted Solution

by:
adnanza earned 50 total points
ID: 1090420
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 Coordinator then you would be able to save all the transactions in both the computers at the same time.
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

Suggested Solutions

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

756 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