I'm devlving into 2005 and specifically mirroring.
Having read the following article ( http://www.microsoft.com/technet/pro.../dbmirror.mspx ),
is mirroring a sensible option as it indicates that it should not be
used in a production environment, yet the SQL2005 seminars I've been to
indicate that this is a worthy option.
Do we also need a witness server, or can this be done (sensibly) with
two SQL2005 servers ?
Currently we have 2xSQL2000 (clustered) servers and a SAN for the data.
If we go down the route of mirroring, it looks like we can get rid of
the SAN and Cluster and use the mirroring instead.
Any advice on the pro's / cons would be appreciated.
Thanks
Ryan 5  2162 
Ryan,
I haven't done too much with mirroring yet but Do we also need a witness server, or can this be done (sensibly) with
two SQL2005 servers ?
It is physically possible to do this with 2 servers (in fact it is
physically possible to do it on 1 server) but it really doesn't make sense.
The server can only be live if it has a quorum (2 out of 3) agree that it is
the live server. If the primary server is one machine and the second
machine contains the mirror server and the witness server both and the
second machine goes off-line you have effectively taken the primary server
off-line as well since it will no longer have a quorum.
HTH,
John
"Ryan" <ry********@hot mail.com> wrote in message
news:11******** **************@ e56g2000cwe.goo glegroups.com.. . I'm devlving into 2005 and specifically mirroring.
Having read the following article (
http://www.microsoft.com/technet/pro.../dbmirror.mspx ),
is mirroring a sensible option as it indicates that it should not be
used in a production environment, yet the SQL2005 seminars I've been to
indicate that this is a worthy option.
It's worth playing with.
BUT, it's beta. Which means if you use it in a production evironment and
something goes wrong, the amount of support that MS will provide is limited.
Do we also need a witness server, or can this be done (sensibly) with
two SQL2005 servers ?
Generally you should have a witness.
Currently we have 2xSQL2000 (clustered) servers and a SAN for the data.
If we go down the route of mirroring, it looks like we can get rid of
the SAN and Cluster and use the mirroring instead.
Any advice on the pro's / cons would be appreciated.
Thanks
Ryan
What do we need licence wise for the witness server ? Will we be able
to use a standard licence ?
You can use any edition for the witness.
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada www.pinpub.com
..
"Ryan" <ry********@hot mail.com> wrote in message
news:11******** **************@ z34g2000cwc.goo glegroups.com.. .
What do we need licence wise for the witness server ? Will we be able
to use a standard licence ?
Ryan, What do we need licence wise for the witness server ? Will we be able
to use a standard licence ?
The witness can be any edition of SQL Server 2005 including the free Express
Edition.
HTH,
John This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: GGerard |
last post by:
Hello
Does anyone know if there's a way to mirror data from a backend database to
a second database?
Example: When writing data to one database it would mirror the data in a
second database for backup
and then if anything should happen to the first database the user could
switch to the second backup database.
|
by: Ian Jenkins, MCSD |
last post by:
I have a mirrored database setup in SQL Server 2005, SP1.
I wrote a .NET client application to insert 1 record every second into
a table within the mirrored database. The idea was to use this client
to test failover scenarios. In my first test I pulled the NIC cable
out from the principal server. I was expecting the client to
automatically start inserting rows again once the mirror became the
principal. This did not happen, instead I...
|
by: KR |
last post by:
Hi,
We are running a test upgrade form sql 2000 standard edition to sql
2005 developer edition. Followed through all the steps and specified
the account(SA priveleges and currently used by the 2000 version) and
is the local admin on the box for the services and the setup seemed to
move fine, except for when it got to the point of installing database
services - This is the error message that I got:
MSSQLServer could not be started. ...
|
by: serge |
last post by:
I have 2 SQL Enterprise Editions running SP2 and same collation.
When i try to start database mirroring I get the following error
message:
"The remote copy of database "ABC" has not been rolled forward
to a point in time that is emcompassed in the local copy of the
database log. (Microsoft SQL Server, Error: 1412)"
Both SQL Server services are running under account
|
by: umeshpotdar |
last post by:
i am doing mirroring on the data base
i have done every step but i got problem below
"Database Mirroring Transport is disabled in the endpoint configuration."
this problem occured when i cilck on the
"start mirroring" button
can anybody know about mirroring
| | |
by: epikto |
last post by:
I am setting up a HA solution which incorporates both the DB Mirroring and Log Shipping with SQL Server 2005.
However I am running into a bit of a snag in configuring the mirror as the primary/inactive log shipped database.
From what I can tell one should be able to configure the mirror DB separately as a logged shipped database and when a mirror failover event happens the Log Shipping jobs should be able to come from whichever is the...
|
by: vishnutd4u |
last post by:
Hi friends,
This is vishnu.Here in our company we have decided to implement database mirroring in mysql.Database mirroring means just when one database server is down the backup database server will take over database server's work just thats i know.But i dont know how to implement that thing.So plz if any one knows help me step by step of implementing in this matter.I am working on VC++ which is on window based(client side).But mysql...
|
by: Lee T. Hawkins |
last post by:
I am having a number of problems over the last two full days trying to get
an ASP.NET 2.0 application to connect to a SQL Server 2005 database...
First off, I built this application w/ Visual Studio 2005 SP1 and had it
working perfectly on my Windows XP machine on SQL Server 2005 Express. I
decided to publish this application to a test development server (with both
the SQL and IIS servers on the same box) running on:
Windows Server...
|
by: pratimapaudel |
last post by:
I need to do the mirroring of my company's production DataBase. I am not planning to setup the witness server. I am planning to do mirroring between two servers only. Can anyone tell me how long it will take? How many hours it will take to setup everything? I have to give the approximate time to complete thhis to my department manager. I appreciate your answer. Thanks
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
