2005 Database Mirroring && Witness

Mar 14, 2006

I'm devlving into 2005 and specifically mirroring.

Having read the following article (
http://www.microsoft.com/technet/pr...5/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

View 5 Replies


ADVERTISEMENT

Database Mirroring | Can Witness Live On Mirroring Server?

May 3, 2008



Server A = primary SQL DBs (mirroring origination)
Server B = failover SQL DBs (mirroring destination)

For database mirroring a witness is required.
Can the witness live in another instance of SQL on server B?

View 7 Replies View Related

Problems On Database Mirroring (Loss Of Mirror And Witness)

Nov 29, 2006

Hi guys , I would like to know what's the exactly results able to get in this following scenario.

Server A : Principal

Server M : Mirror

Server W : Witness

1) Firstly, disable server M, following by server W. So probably i will unable to connect to Server A eventhough it acts as a principal.

2) Next, if I enable either server M or server W , what will I able to get actually ? Is it the mirroring works like the article which written in Microsoft page ?(http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx#ETPAE)

At here, I get an error message and unable to continue the mirroring section. ( "Database EMS is enabled for Database Mirroring, but neither the partner nor witness server instances are available: the database cannot be opened." or "Database 'EMS' is being recovered. Waiting until recovery is finished." )

3) If I enable both server M and server W, the mirroring continue to work again.

Can I have any assistance on (2) issue? Thx for the assistance.

Best Regards,

Hans


View 3 Replies View Related

Mirroring :: 2012 Database Mirror Missing Witness Server Information?

Oct 24, 2015

missing witness server information and the fail-over is broken suddenly? 4:00am no maintenance job. I have one sql job on 10pm for backup on database transaction log only.

I can see the primary have problem then perform fail-over to mirror database, the auto fail-over was broken.

I re-build the sql mirror is OK , but i want to find the root cause.

Windows application event was full when there have many failed event, i have increase log size for application event.  

View 7 Replies View Related

SQL Mirroring Witness

Sep 14, 2006

I have managed to set up mirroring on SQl 2005 however i have a come across a problem that i dont know how to resolve.

Im running the mirroring with 'High Safety with automatic failover.'

If i instagate a failover on the Principal Database, the mirror becomes the Principal, and vice versa ... great .. how ever .. i tried the golden test by making the principal server dissapear by yanking out the network connection, expecting the mirror to become the principal.....nope it just stays there in a disconnected / restoring state which isnt any good to man nor beast . I thought that the Witness should have dectected that the principal database had 'dissapeared' and would have made the mirror the Principal.

Any pointers on where i might have gone wrong in the setting up process, i used the mirror wizard

View 2 Replies View Related

Witness Server In DB Mirroring

Jan 28, 2008

Can 1 witness server work for 4 Principal and mirror servers?
Needs expert advise.

View 1 Replies View Related

SQL 2012 :: Mirroring In Two Servers With Witness?

Jun 19, 2014

One of my client asking mirroring between two server with witness.Is it possible witness and mirror in same server(with same instance)? OR Is it possible witness and primary in same server(with same instance) ? Best method to establishing mirroring with in two servers(with witness) ?

View 4 Replies View Related

Mirroring The Databases Without Witness Server?

Jul 10, 2013

I need to start mirroring the databases without witness server.

View 3 Replies View Related

Mirroring :: Unable To Add Witness Server

Sep 14, 2015

I am unable to add witness server to my mirror configuration. my error log is throwing error'Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not found. State 89'.

View 5 Replies View Related

Recovery :: Where To Place Witness Server For Mirroring Using High-safety And Auto-failover

Apr 9, 2015

We have 2 data centers, site 1 and site 2.  Site 1 is generally our primary, and site 2 is our Disaster Recovery (DR) site.  I want to setup a SQL instance to have extremely high availability.  Therefore I was looking at using DB mirroring, with synchronous data writing, high-safety and auto-failover.  This requires the usage of a witness server.My problem with this setup, is that if the witness and principal are both at site 1, if site 1 goes away (power failure, asteroid impact, lol, anything else that would be a *true* DR scenario), then there is no failover to the mirror server at site 2.   However, if you put the witness at site 2, anytime the WAN link between site 1 and site 2 has an issue, the DB will auto-failover to site 2.  Is the reason for the recommendation of the witness being at the primary site because the thinking is that WAN link failure is likely more common than a *true* DR scenario that takes out all of site 1?

View 3 Replies View Related

Mirroring :: How To Reduce LDF Size While Mirror Enabled With Mirror And Witness Server

Jun 14, 2015

I am using SQl Server 2012 Database Mirroring with around 40 gb as mdf and 1 gb as ldf. Now my ldf size increased . How to reduce ldf size while mirror enabled with mirror server and witness server. Can shrink the ldf with mirror enables.

View 4 Replies View Related

Mirror And Witness Connection In A Disconnected State Immediately After Adding Witness Server To Mirror Session.

Jan 31, 2008


After adding the Witness Server to the Mirror session, the Witness Connection state between the Mirror and Witness Connection is Disconnected and the state between Principal and Witness Connection is Connected.

The procedures defined in Books Online was used to setup Database Mirroring...when the Witness server was added to the Mirror session, only the alter database T-SQL statement was executed on the Principal server.

ALTER DATABASE <db_name> SET WITNESS = 'TCP://<servername>:<port>'

After executing the above statement, a few seconds later the state between Principal and Witness Connection changed to Connected and the state between Mirror and Witness Connection remains Disconnected.

The Mirror session is not using Certificates, every server is on the same domain, using the same domain login account, and all servers have SP2 installed running Enterprise Edition.

Any idea's why the state between Mirror and Witness Connection remains Disconnected?

Thanks,

View 9 Replies View Related

Mirroring For Certain Tables From The Database In Sql 2005

Nov 7, 2006

Can I know is it possible using database mirroring for only certain tables from the database, not for the whole database in sql server 2005. Hopefully able to get any assistance here. Thx alot.

Best Regards,

Hans

View 4 Replies View Related

SQL 2005 Database Mirroring - AD Required?

Oct 10, 2005

Hi, for SQL 2005 - to set up database mirroring, is it required to have Active Directory installed or to be part of a domain? I am looking to use a workgroup with the SQL machines only and to not reference any domain and cannot find this information - is this possible?

View 5 Replies View Related

Database Mirroring Between 2005 Editions

Feb 1, 2007

Can I use Database mirroring between 2005 Std and 2005 Ent editions?

View 2 Replies View Related

SQL Server 2005 Database Snapshots With Mirroring

Mar 8, 2007

Hello, My question is simply: according to BOL, a DB snapshot taken from a Mirror is read-only.  Say I wanted a temporary (disposable) read-write DB created from the snapshot.  Is there a way to generate a writable temp DB (that's not tempdb) from the snapshot? Thanks,AK 

View 1 Replies View Related

Database Mirroring Support Also By SQL Server 2005 Without SP1

Sep 27, 2006

Hi All,

I get a general question about the feacture "Database Mirroring". Is it support by SQL Server Standard. Edition without SP1?? Of i still need to upgrade the server from SQL Server 2005 to SQL Server 2005 with SP1?

Another question: are there any problem if the one machine(server) has installed SQL server 2005 Standard edition and the other with "Developer Editon".

I hope some one can answer my question. Thanks anyway!

Regards,

Pat

View 5 Replies View Related

SQL Native Client 2005 Connect To Database Mirroring

Apr 7, 2008



Hi all,

i have a small problem to connect SQL Native ODBC Client to a mirrored Database.
The connection goes without any problem when I connect to a primary Database, but when i give this connect string to an
ODBC Client ""Server=Partner_A; Failover Partner=Partner_B; Database=XXX; Network=dbmssocn"", then i get an connect fail.
There are no firewalls and other things on the network.
I am also able to connect to a mirror database during failover, but I'm not able to set both servers on the ODBC Connection.

Kind Regards,
Gruna

View 15 Replies View Related

SQL SERVER 2005 Database Mirroring For Large Number Of Databases

May 30, 2006

I am trying to enable database mirroring for 100 database.
It goes error free till 59 databases (some times 60 databases) with the
status (principal, synchronized) on principal. on the 60th or 61st database
it gave the status (principal, disconnected). Also mirror starts acting
abnormal. connection to mirror starts to give connection timeout and it is
not enabling database mirroring on any more databases. I have SQL SERVER
2005 Enterprise with SP1 on the servers. witness is not included yet.

this are my test servers... i have more than 500 databases on my production
servers.

principal and mirror both are using port 5022 for ENDPOINT communication.

View 1 Replies View Related

SQL Server 2005 Evalution Copy Database Mirroring In NT 4 Domian

Jul 17, 2007

Dear All,



I have a download "SQL Server 2005 Evalution Copy". I installed it to 3 machine, 1 - XP Professional (Witness) and 2 - Windows Server 2000 (Principle and Mirror) . And I want to try Database mirroring.



However, after restore the Log into mirror server I try to execute the following statement in Principle Server:

ALTER DATABASE TestDB
SET PARTNER=N'TCP://[10.0.200.2]:5022'
GO

The above 10.0.200.2 is the mirror server IP address.

it show error message as:

Msg 1416, Level 16, State 31, Line 1
Database "SCMPGroup" is not configured for database mirroring.



In Miorror Server

I execute the statement :

ALTER DATABASE TestDB
SET PARTNER=N'TCP://[10.0.200.1]:5022'
The above 10.0.200.1 is the principle server IP address.

It shows sucess



ALTER DATABASE TestDB
SET WITNESS=N'TCP://[10.0.15.146]:5022'

it show error message as:

Msg 1416, Level 16, State 1, Line 1
Database "SCMPGroup" is not configured for database mirroring.



Please help me! I down't know if NT4 domain or evalution copy problem in there.

View 3 Replies View Related

SQL SERVER 2005 DATABASE MIRRORING For Large Number Of Databases

Jun 1, 2006

I am trying to enable database mirroring for 100 database.
It goes error free till 59 databases (some times 60 databases) with the
status (principal, synchronized) on principal. on the 60th or 61st database
it gave the status (principal, disconnected). Also mirror starts acting
abnormal. connection to mirror starts to give connection timeout and it is
not enabling database mirroring on any more databases. I have SQL SERVER
2005 Enterprise with SP1 on the servers. witness is not included yet.

these are my test servers... i have more than 500 databases on my production
servers.

principal and mirror both are using port 5022 for ENDPOINT communication.

All of the databases are critical and all must be included in the Database Mirroring.
so, after that I tried to implement database mirroring again......
System has 3 GB of RAM, SQL SERVER (Mirror) using 85 MB of RAM but still
giving this error while trying to enable database mirroring for 37th
Database.....

"There is insufficient system Memory to run this query"

WHY?

View 19 Replies View Related

Article: Database Mirroring Not Ready For Production When SQL Server 2005 Ships

Sep 16, 2005

Can someone at Microsoft comment on this article, specifically, how it relates to SQL Replication?  Will SQL Replication fall into the category of what this article describes, or only the mirroring feature?

View 1 Replies View Related

Mirroring :: Database Mirroring Changes In Application

Oct 12, 2015

Using SQL Server 2008, we would like propose mirroring between two servers of a critical database. Since we initiate, may require to clarify on its purpose and also required changes from application end.Any changes required from OS Level? (I believe both servers IP or Host name should be added in host entries. Mirroring ports should be allowed/open including Principal and mirror server IP Addresses): Windows Team.Any changes required from Application? (Instance name, authentication: user name and its password should be added in web config files): Application Team.Any changes required from Network Team?Also for mirroring both the principal and mirror servers should be with same version, does it only mean SQL Server 2008 versions are enough or does it also mean to say build numbers 10.00.4000 should also be same.URL....

View 5 Replies View Related

SQL 2012 :: Database Mirroring And NT Authority Account For Database Engine?

Dec 2, 2014

I have just finished configuring my first test mirrored environment (High safety mode). I setup the database engine service accounts on each of the servers with domainuser. I inherited a production mirrored environment set up by someone else. On the production servers the database engine service account is NT Authorityuser a local account. I am trying to practice installing Windows updates within a mirrored environment and I not sure how to proceed when the service account is NT Authority user account. should I change the service account to a domainuser?

View 2 Replies View Related

The Database Is Being Closed Before Database Mirroring Is Fully Initialized

Jun 12, 2007

When I issue this command:


ALTER DATABASE foo set PARTNER = 'TCP://10.3.3.1:1234'
I get this error message:




The database is being closed before database mirroring is fully initialized. The ALTER DATABASE command failed.
What does that mean, and how do I fix it?

View 8 Replies View Related

Database Mirroring Hangs On ALTER DATABASE SET PARTNER

Jun 26, 2005

Hi,

View 6 Replies View Related

SQL 2005 Mirroring

Jul 12, 2007

I am trying mirroring in my own laptop in 2 different instances of 2005 but when i configure it gives me an error "one or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click start mirroring again"



does anyone know what is the problem???? i read one post but could not understand properly.

Narayan

View 8 Replies View Related

Sql 2005 Mirroring

Dec 28, 2006

i setup sql 2005 mirroring

when i run the wizard and start mirroing i get the folllowing error:1418

in the log it says database mirroring login attempted by user NT AUTHORITY/ANONYMOUS logon does not have connect permissions on the endpoint

my service acount is LOCAL SYSTEM

all 3 sql servers are in same workgroup

i can connect with studio to all 3 with no problem

any one have any clues here

View 1 Replies View Related

SQL 2005 Mirroring

Jul 31, 2007

Hi everyone,
I have a project on my hand in which i need to implement two SQL 2005 servers
And configure it as DB mirroring.
I know that for the sake of 'fail over' I need to configure a witness
server as well.


My question is:
For the purpose of the mirror server and the principle server - what
are the software requirements (enterprise, standard?)
For the purpose of the witness server - what are the software
requirements (enterprise, standard, express?)
Should the witness server be a 'server' in terms of hardware...or is
it enough to establish a strong pc machine?

View 3 Replies View Related

Database Mirroring Monitor Not Working For One Database

Apr 2, 2008

I set up a new mirror server. Everything is good except that the Database Mirroring Monitor is not working for one of the databases. In the monitor the principal data is showing up as blank

If I look at dbm_monitor_data on the principal most of the data columns (e.g. Send_queue_size) are null where as they have data for the other databases.


Both servers are SQL Server 9.0.2047 Enterprise Edition.


Any idea what might be going on here?


Thanks in advance.

View 3 Replies View Related

SQL 2005 Mirroring Questions

Apr 25, 2007

Hi guys,
 I have read many articles on the matter and I have probably used up all my printer's ink in doing so,  however, some questions still remain.
1) What happens if I have to reboot the mirror.. security update, etc.? Obviously the session is broken during reboot, but would I have to do another backup of the principal and resync everything?
2) I know it is not best practice but at this point I have no choice, however, I wanted to get your guys feedback on having two instances of SQL2005 on my development box. One for the mirroring of the production and the second for development. The two instances would live on their own drive... not partitioned and have adequate memory and space.
What would I have to look forward with this?
3) Lastly, I am still uncertain if mirroring is approved for production. Is it?
 
Thanks for your help.

View 4 Replies View Related

SQL Server 2005 Mirroring

Jul 20, 2007

I am working on a proof of concept to take to our Technical Board.

This POC is concearned with SQL server 2005 Mirroring for High Availability and Failover in a Highly Critical business sector.



The problem is that we use custom web pages to give the Operations Center an overview of the status of the system and that there are so many metrics available (not may are well documented). I have looked at the following



sys.database_mirroring_witnesses

is_suspended to show the state of the Sync

database_name to return the name of the mirrored database

safety_level_desc to show that the Safety level is at Full

Principal_server_name to show the name of the Principal server

Mirror_server_name to Show the Name of the Mirror Server.





I am at a loss as to what is the best approach as I do not want to display too much Information and confuse.



The Servers are locked down to remove any permissions not required so I have to create a SQL account with only acces to the required sys views. one issue is that the following SQL only works on the Principal




Code SnippetSelect * from sys.database_mirroring where mirroring_guid is not null



The Principal returns




Code Snippet

7 267CF8D3-8066-44EA-84BD-B7EA25C3F779 4 SYNCHRONIZED 2 MIRROR 20 2 FULL 1 TCP://DNGLHRSQL051.XX.XX.XXX:5022 DNGLHRSQL051 TCP://LHRSQL029.XX.XXX.XXX:5023 1 CONNECTED 40000000010300001 10 NULL UNLIMITED



where the Mirror will return nothing..



The configuration of the User is identical on both Principal and Mirror and is as follows

Master Public

MSDB Public, dbm_monitor





I have read that the User also requires "view any Database" but on the Mirror this database is not available on the Mirror as it is in Sync.



Is this an undocumented Feature?



Any help greatly appreciated



Regards



Andy

View 4 Replies View Related

SQL Server 2005 Mirroring

Aug 16, 2006

I am trying to set up a SQL mirroring senario - I have some questions

Do I need to purchase an extra SQL Server license for the SQL server instance on the Mirror? what about the Witness does that also need a separate license/

Can the witness be a virtual server on the Mirror box itself? Do I still require a license if the witness is on a virtual server?

Thanks

jawahar

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved