Dear Sir/Madam,
Hello,
I'm a MCSA and administrator of a large scale company, we have two
member server (with the same hardware configuration) that both have SQL
Server.
On one of these servers we have a SQL database that it stored more than
600,000,000 characters and everyday 700,000 characters added to it.
I really don't have information about SQL Server , Databases and how to
replicate them.
Would you please guide me that how can I easily replicate this important
database in these both servers, to have a redundant databases?
Yours Sincerely,
Ahmad Reza
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Ahmad,
there are various options for redundant databases. The classical one for
your situation is not actually replication, but is log shipping. There is
plenty of information in books on line about how to set it up (quite
straightforward). To use it out of the box, you'll need enterprise edition
of sql server, but if you have standard then there are scripts on the
resource kit to do it. There are other options and in a previous post
Michael Hotek lists his selection in this order which I agree with:
1. Transactional with queued updating
2. Merge
3. Transactional
Please post up any further questions.
Regards,
Paul Ibison
|||I would suggesting looking at the information in SQL Server 2000 Books on
Line. The types of replication available in SQL Server 2000 are documented
there as well as how to set them up.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I would also add that the word "easy" doesn't come into play here. Is it
complicated? No. Is it complex? Yes. You need a good understanding of
what a SQL Server is, what it does, and how it operates before even
attempting replication. If you don't start there, it is a very quick route
to blowing up an environment. That is NOT due to replication. It is due to
the way that data reacts and is handled in a distributed environment that
introduces many added challenges that simply don't exist on a single
machine. If there is a way to accomplish what you need without using
replication, my strong recommendation is to use the other solution.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com
No comments:
Post a Comment