Solved

Replicating or mirroring SQL Database

Posted on 1998-10-06
5
324 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
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 ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

856 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