Hello:
I have 2 MS SQL Servers 2000 Developer edition.
Both have same settings and databases. I'd like to have them as mirrored
servers - all transaction on one server must be performed on the other
automatically. More than that I'd like to get possible if something happened
to one server, all transactions will be performed on another one.
Please, give me a hint how to do that.
Thanks,
GB
6  1263 
GB (v7****@hotmail.com) writes: I have 2 MS SQL Servers 2000 Developer edition.
Both have same settings and databases. I'd like to have them as mirrored
servers - all transaction on one server must be performed on the other
automatically. More than that I'd like to get possible if something
happened to one server, all transactions will be performed on another
one.
Symmetric or one-way? If one server is a main server, and the other is a
standby server, you can use either log shipping or transactional
replication. Log shipping is easier to manage, as transactional
replication leaves its mark on the source database. On the other hand,
the standby server will not be accessible each time a log is applied,
and the lag time is longer.
If it is symmetric, that actions are to be replicated in both directions,
then you may want to look into merge replication. But this sounds anything
about trivial to me. What about if the same row was updated in both
databases? Who wins?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
The only purpose I have is to have a "backup" server to be ready
to substitute main server at any time with recent data in it
and "seamless" switching in production mode.
"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn*********************@127.0.0.1... GB (v7****@hotmail.com) writes: I have 2 MS SQL Servers 2000 Developer edition.
Both have same settings and databases. I'd like to have them as mirrored
servers - all transaction on one server must be performed on the other
automatically. More than that I'd like to get possible if something
happened to one server, all transactions will be performed on another
one.
Symmetric or one-way? If one server is a main server, and the other is a
standby server, you can use either log shipping or transactional
replication. Log shipping is easier to manage, as transactional
replication leaves its mark on the source database. On the other hand,
the standby server will not be accessible each time a log is applied,
and the lag time is longer.
If it is symmetric, that actions are to be replicated in both directions,
then you may want to look into merge replication. But this sounds anything
about trivial to me. What about if the same row was updated in both
databases? Who wins?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
GB (v7****@hotmail.com) writes: The only purpose I have is to have a "backup" server to be ready
to substitute main server at any time with recent data in it
and "seamless" switching in production mode.
OK. The I would suggest log shipping.
However, you cannot really switch into real production mode with
Developer Edition, as you don't have a license for it. But it is
of course, perfectly OK to set up log shipping to learn how to
use it for a production scenario.
Oh, I should add that once you come to production, you may only
have Standard or Workgroup Edition. Log Shipping is included in
Enterprise Edition only, so for these edition replication is about
the only option.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
In message <Xn*********************@127.0.0.1>, Erland Sommarskog
<es****@sommarskog.se> writes GB (v7****@hotmail.com) writes: The only purpose I have is to have a "backup" server to be ready
to substitute main server at any time with recent data in it
and "seamless" switching in production mode.
OK. The I would suggest log shipping.
However, you cannot really switch into real production mode with
Developer Edition, as you don't have a license for it. But it is
of course, perfectly OK to set up log shipping to learn how to
use it for a production scenario.
Oh, I should add that once you come to production, you may only
have Standard or Workgroup Edition. Log Shipping is included in
Enterprise Edition only, so for these edition replication is about
the only option.
If GB wants clustering and failover I think he will need the enterprise
edition.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.
Bernard Peek (ba*@shrdlu.com) writes: If GB wants clustering and failover I think he will need the enterprise
edition.
That is correct. (OK, since Developer Edition has all that Enterprise
Edition has, you can put that on a cluster. But if you put Developer
Edition on a cluster, then your hardware budget for your development
environment is quite excessive.)
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
"Bernard Peek" <ba*@shrdlu.com> wrote in message
news:ah**************@shrdlu.com... In message <Xn*********************@127.0.0.1>, Erland Sommarskog
<es****@sommarskog.se> writesGB (v7****@hotmail.com) writes: The only purpose I have is to have a "backup" server to be ready
to substitute main server at any time with recent data in it
and "seamless" switching in production mode.
OK. The I would suggest log shipping.
However, you cannot really switch into real production mode with
Developer Edition, as you don't have a license for it. But it is
of course, perfectly OK to set up log shipping to learn how to
use it for a production scenario.
Oh, I should add that once you come to production, you may only
have Standard or Workgroup Edition. Log Shipping is included in
Enterprise Edition only, so for these edition replication is about
the only option.
If GB wants clustering and failover I think he will need the enterprise
edition.
SQL Server 2005 will be released with DB mirroring, though in a "beta form".
He may want to look at this.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Meghna |
last post by:
Hi,
I was wondering if some one would be able to help me with this. I am
trying to share a session across two servers and I seem to be
experiencing some problems. I was wondering if anybody has...
|
by: Captain Ranger McCoy |
last post by:
Hello!
Suppose I have ten servers at ten ips:
x.x.x.1
x.x.x.2
x.x.x.3
x.x.x.4 and so on
Each server hosts 100+ photo galleries, all under a single domain name,
|
by: Oliver Braun |
last post by:
I know this is a very common issue and I found a lot of hints on this topic
in www but I did not find a very good solution for this task.
Most of the solutions use SQLDMO to list all sql servers...
|
by: Jeff Kish |
last post by:
hi.
I've seen ways to delete duplicate rows.
Can someone give me some sql to do this?
I have a table with varchar table_name_start, varchar column_name,
varchar table_name_end;
it has rows...
|
by: denz |
last post by:
Hi,
Basically, in the client proxy that is refering to a web service, i want to
be able to switch automatically and transparently, from one URL to another
(location of the mirrored service) when...
|
by: Ben Holness |
last post by:
Hi all,
I have a php/mysql website where people can upload their own graphics for
the buttons and background of pages on the website.
This used to run on one server, but I have now been asked...
|
by: Hari2005 |
last post by:
Hi
Is there anyone who will tellme that what is the meaning of mirrored site eg.europian mirror site or usa mirror site?????????????
Thanks in advance.
|
by: Samir Chouaieb |
last post by:
Hello,
I am trying to find a solution to a login mechanism for different
domains on different servers with PHP5.
I have one main domain with the user data and several other domains that
need...
|
by: Bill Fuller |
last post by:
Has anyone here had experience using technologies such as StateMirror
(www.statemirror.com) as an alternative to managing state on a per server
basis (thus requiring sticky-sessions in a web farm)...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
