?
Solved

mirroring sql server 2000 database

Posted on 2005-04-25
3
Medium Priority
?
189 Views
Last Modified: 2011-10-03
I am a new bie. I would like to know  how a mirroring of Ms-sql2000 Server Data base is possible.
1>Can some one guide me to the relevant links or articals.?
2>Do I need External Tools to do mirroring or is it an avaliable feature of Ms-SQL 2000. ?
3>How does RAID help Us for paralel  Server.?
0
Comment
Question by:RAJESH SHARMA
1 Comment
 
LVL 29

Accepted Solution

by:
rdivilbiss earned 80 total points
ID: 13868245
In MS-SQL it is called replication and there are plenty of how to articles in MSDN.

There are three types of replication:
# Snapshot replication acts in the manner its name implies. The publisher simply takes a snapshot of the entire replicated database and shares it with the subscribers. Of course, this is a very time and resource-intensive process. For this reason, most administrators don’t use snapshot replication on a recurring basis for databases that change frequently. There are two scenarios where snapshot replication is commonly used. First, it is used for databases that rarely change. Second, it is used to set a baseline to establish replication between systems while future updates are propagated using transactional or merge replication.

# Transactional replication offers a more flexible solution for databases that change on a regular basis. With transactional replication, the replication agent monitors the publisher for changes to the database and transmits those changes to the subscribers. This transmission can take place immediately or on a periodic basis.

# Merge replication allows the publisher and subscriber to independently make changes to the database. Both entities can work without an active network connection. When they are reconnected, the merge replication agent checks for changes on both sets of data and modifies each database accordingly. If changes conflict with each other, it uses a predefined conflict resolution algorithm to determine the appropriate data. Merge replication is commonly used by laptop users and others who can not be constantly connected to the publisher.

You do not need third party tools to do replication, although there are several available.

RAID really isn't an issue with replication other than it makes disk transactions faster.  Certainly RAID can also provide its own form of disaster recovery being a redundant array, but replication refers to making a copy on a different server.

Some links:
http://www.mssqlcity.com/Tips/replication_optimization.htm
http://www.databasejournal.com/features/mssql/article.php/3391321
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_upgrade_45ir.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/repltools_2zle.asp
0

Featured Post

Independent Software Vendors: 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

Most of the sites are being standardized with W3C Web Standards. W3C provides lot of web standard services to the web. They have the web specification, process and documentation for all the web standards. You can apply HTML, CSS and Accessibility st…
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…
Suggested Courses

850 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