Database Mirroring Forum

Question about high-safety mode read-time

Tue, 24 Nov 2009 15:40:31 Z

Hello all. Please bear with me - I've never set up mirroring, but I am trying to read up on it.

We are planning on setting up mirroring on our production SQL server database. Both Principal and Mirror (Witness too, if we decide we need it) will be on a Windows Server 2008 virtual box, running SQL Server 2008 Enterprise Edition. I'm aware that in high-safety mode, the Mirror has to commit the changes before the Principal commits the changes. Does this mean that if I write a record to the Principal, and it takes 10 seconds to commit on the Mirror, that nobody will be able to see this change in the Principal for those ten seconds? Logically, it sounds like this is true because, otherwise, the Principal would be performing dirty reads.

I guess I just wanted to hear it confirmed from someone else.

Thanks in advance.

Clint

Mirroring clarification

Sat, 28 Nov 2009 12:59:24 Z

Hello ,

I have couple of questions regarding mirroring and I need all your help, once I am clear then I can look for implementing either mirroring or log-shipping. Can anyone help me understand what are the difference between log shipping and mirroring what happens if mirror server is down or
what happens if principal is down? can i still access my mirror database in the above conditions

Regards
Rithu

copy views from one db to another in the same server

Thu, 26 Nov 2009 22:10:47 Z

I want to copy a few views across two databases within the same server in sql 2005. Can you please provide some help? Thanks

One or more of the server network addresses lacks a fully qualified domain name (FQDN).

Mon, 11 Jun 2007 09:31:16 Z

Hello Guys,

I had been trying to solve this error with no success :

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.

The syntax for a fully-qualified TCP address is:
TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port>

I had installed three instances on my local machine to test Data base mirroring :

Principal : running SQL Developer Instance

Mirror : running SQL Developer Instance .

Witness : Running SQL Express.

Database mirroring already enabled using startup flag : -T1400

i even tried to configure it with out a witness but still have the same error .

I used the follwoing server name in the mirroring wizard(not localhost) :

Principal : TCP://Ali-laptop:5022

Mirrored : TCP://Ali-laptop:5023

Witness : TCP://Ali-laptop:5044

whats the problem guys?!

database mirroring error 1418

Mon, 23 Nov 2009 19:15:23 Z

Database mirroring setup error 1418:

Error set mirror server instance as a partner from the principal sever instance:

Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://HQINTRADEV1.RP.INTRANET.URG:1433"
can not be reached or does not exist.
Check the network address name and that the ports for the local and
remote endpoints are operational.

My environment:

Two severs running SQL Server 2005 SP3.(Windows 2003, sp2)

Procedure:

1) created endpoint on principal
    CREATE ENDPOINT ENDPOINT01OMDB05
     STATE=STARTED
     AS TCP (LISTENER_PORT =1433, LISTENER_IP = ALL)
     FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE,
     ENCRyPTION = REQUIRED ALGORITHM RC4)

2) created endpoint on mirror server:
   CREATE ENDPOINT ENDPOINT01OMDB05
     STATE=STARTED
     AS TCP (LISTENER_PORT =1433, LISTENER_IP = ALL)
     FOR DATA_MIRRORING (ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE,
     ENCRyPTION = REQUIRED ALGORITHM RC4)

NOTE: did not create a login account. plan to the use the administrator domain and ID that was used
to create the endpoints.

3) backup database and log on principal

4) restored database and log on mirror WITH NORECOVERY option

5) On the mirror server set the principal server instance as a partner
ALTER DATABASE OMDB05
SET PARTNER ='TCP://HQSHOP01.RP.INTRANET.URG:1433'
This completes successfully

6) on the principal server set the mirror as a partner

   ALTER DATABASE OMDB05
      SET PARTNER ='TCP://HQINTRADEV1.RP.INTRANET.URG:1433'
   received the below error:

    Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://HQINTRADEV1.RP.INTRANET.URG:1433" can not be
reached or does not exist.
Check the network address name and that the ports for the local and remote
endpoints are operational.

I can communicate between these two servers. I currently have Replication working between these servers.

Can I run run Mirroring and Replication on the save servers at the same time?

I also see the following error in the LOG on the mirror server:

Server TCP provider failed to listen on ['ANY' <'ipv4'> 1433]. TCP port already in use.

I have read a lot of postings about this error but still cannot get this problem resolved.

Thanks in advance for your help.

Thanks Lekss,

I tried your recommendation. It did not work. I got the same error message.

Could this be a security problem? I am getting the following error message in the log:

Error: 1443, Severity: 16, State: 2 (which seems to indicate a security problem)

I did not create a login account. I am using the Windows domain\administrator id.

Thanks

MetaData about mirroring

Tue, 24 Nov 2009 13:54:39 Z

Is there a way to query system tables or use DATABASEPROPERTY to get a list of all databases that are mirrored on a server.

I see sys.databases has many columns involving replication, service broker, etc but I see nothing on mirroring and also I looked up DATABASEPROPERTY and DATABASEPROPERTYEX in BOL and see no properties regarding mirroring

mirroring more than one

Wed, 18 Nov 2009 12:53:05 Z

Hi,

there are 3 servers. can there be more than one principle and only one "partner" server?
another word, i have the databases from different servers, servermst1 and servermst2 to mirror off to one single serverpartner?

thanks.

mirror a table

Tue, 17 Nov 2009 01:01:53 Z

I need to create a mirror image of a table in another SQL Server database. I just started work at this company and don't kow much about SQL Server. I was wondering if there is a location in the MS SQL Server Management Studio application taht shows if there was a script used to build the tables? If so where would they be placed or how would I find them in Management Studio?

chuckdawit

database mirroring

Tue, 17 Nov 2009 14:23:23 Z

I have some questions about database mirroring:

What is the witness server, is it another sql server?

How do you setup the witness server?

Is there anyway to setup the mirror server as the witness server?

Does anyone have a first hand account for of how well a VM machine works as the mirror?

Ex-Database Mirror Continues to Synchronize

Tue, 03 Nov 2009 07:00:08 Z

Hi All,

Recently we decommissioned at old server on which we had out Mirror databases. We moved all the databases to the new server and reestablilshed mirroring.

However, one of our databases remains in Synchronizing mode, with 0 unsent log, and remained in this state for a good couple of hours. Perhaps part of the problem is where Database Mirroring Monitor shows the removed/old mirror pair also as Synchronizing. As this caused other issues I removed the new mirror and left the database standalone.

After this we rebooted the decommissioned server, then shut down and removed it from the network. We then rebooted the 'principle' server and reestablished mirroring. But we ge the same result: the new pair shows Synchonizing, and so does the old pair, even though old-mirror server no longer exists. It is worth mentioning that no other mirrored pair exhibited this behaviour.

I'm at a bit of a loss how Database Mirroring Monitor is managing to send logs to a non-existant server, so I'm hoping someone has some ideas on how to resolve this issue.

Thank.

Database Mirroring - 'NT AUTHORITY\ANONYMOUS LOGON.' failed

Thu, 14 Dec 2006 14:42:10 Z

Hello,

I have set up 3 servers - Primary, Mirror and Witness. When I run the database mirroring wizard all my endpoints are configured, but when i start the mirroring service i get a 1418 error - in the logs in says -

Database Mirroring login attempt by user 'NT AUTHORITY\ANONYMOUS LOGON.' failed with error: 'Connection handshake failed. The login 'NT AUTHORITY\ANONYMOUS LOGON' does not have CONNECT permission on the endpoint. State 84.'. [CLIENT: 10.20.1.5]

I have looked through the BOL and can't find anything helpful. - I'm pretty new to SQL server, so any help is very much appreciated!

Thanks

Kerpoise

Maintenance Plans

Wed, 11 Nov 2009 22:28:14 Z

Hi All

I have a couple of questions about Maintenance plans when using Mirroring on a SQL 2005 platform that i am sure someone who uses it will be able to answer. (PLEASE).

My goal is to use the mirror only in times of severe troubles when all DB's would become principal on the mirror, and the old principal would be offline.

1) If i set up identical maintenance plans for Backups (full , diff, log) on both the principal and the mirror i imagine that i should disable the mirror ones untill needed as the db's will be in a recovering state.
I know that i could set up a job to skip over db's that are in a recovering state on the mirror but at this stage can not see a time when they would reside on the mirror for long in emergency due to our highly available virtual environment.

2) Is there anyway that the principal and the mirror could become out of sync with each other over a period of time? I have read as much as i can and it does not appear that it should happen however i would like to hear real life experiences.

3) Does the transactio log on the mirror just keep growing? If so how do you shrink it do you have to promotethe mirror to a principal then shrink it?

Thanks in advance everyone.
Cheers
Phil

Transferring Logins SSIS task and DB mirroring

Mon, 12 May 2008 14:37:22 Z

Hi guys,

I want to create an automatic job on SQL 2005 to transfer logins between 2 servers, (Principle and Mirror). If I use the transfer logins task I get the error:

"The database "x" cannot be opened. It is acting as a mirror database."

I guess this is because it is trying to assign the default databases for the logins??

I've also looked at [sp_help_revlogin] procs but that requires manual intervention.

How does everyone else transfer logins in this situation?

Thanks in advance..

sql server performance low

Thu, 12 Nov 2009 06:46:56 Z

I am working on different database at same time while working on these database the sql server performance goes very low.

Event ID: 28047

Wed, 04 Nov 2009 21:34:16 Z

Hello All,

I have this in my event log:

Event ID: 28047
Database Mirroring login attempt failed with error: 'Connection handshake failed. Ther certificate used by this endpoint was not found: Certificate expried. Use DBCC CHECKDB in master database to verify the metadata integrity of the endpoint: State 85.

I did not know that these certificates could expire, if that is the case.

My Principal server has a status of (Principal, Disconnected) for all the databases
My Mirrored server has a status of (Mirror, Disconnected/In Recovery) for all the databases.
I use no witness server. I handle failover using high performance.

Any help would be appreciated.

endpoint name

Thu, 05 Nov 2009 15:07:53 Z

anyone know how in sql 2005 to get the endpoint names used to create the mirroring?

thanks

SQL Server 2005: Unable to manually fail over at the mirror in High Availability operating mode

Mon, 02 Nov 2009 16:01:55 Z

According to the book I'm reading, one is supposed to still be able to manually fail over at the mirror in high availability operating mode when the principal fails while the witness is offline. When I try to fail over at the mirror in this scenario, the following error message is displayed:

Msg 955, Level 14, State 1, Line 1

Database <database_name> is enabled for Database Mirroring, but neither the partner nor witness server instances are available: the database cannot be opened.

This seems to say that it's impossible to manually fail over to a mirror in High Availability operating mode when the principle fails while the witness is offline.

Could the book be wrong, or am just being silly?

Cluster Confusion

Fri, 30 Oct 2009 13:11:37 Z

Hi,

I am by no means a SQL Guy but was looking to clarify few doubts on SQL clustering. Please help me with below questions and elaborate if possible:

1) Default Fail Over cluster with 2 nodes in SQL server is done with shared storage, ideally a SAN or shared disk, right?
2) It can either be SAN or Mirror, both can't be used at single time and don't make sense, right?
3) I hear few people saying active / active is not possible with SQL Server while some say it's there, also there can be a multinode cluster. What's truth here?

Niraj

Witness server suddenly stopped working

Mon, 12 Oct 2009 12:52:33 Z

We failed over to our mirror server over the weekend to carry out some electrical maintenance in the server room, and then when attempting to fail back over afterwards one of the database was fine, but the other was stuck in "synchronising" state and refused to fail over. In the end we disabled mirroring, backed up the database and dumped a log, restored onto the main server and started mirroring again with no problems.

When I tried to link the witness back up to the database I got:

The ALTER DATABASE command could not be sent to the remote server instance 'TCP://MYWITNESSSERVER:7024'. The database mirroring configuration was not changed. Verify that the server is connected, and try again.

And looking at the event log on the witness, it is absolutely littered with error messages from SQL Server, e.g.

Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed: (5) 5(error not found). State 87.'. [CLIENT: (our main server ip)]

A cryptographic operation failed. This error indicates a serious problem with SQL Server. Check the SQL Server error log and the Windows event logs for further information.

A system cryptographic call failed during a Service Broker or Database Mirroring operation: system error '5(error not found)'.

An SNI call failed during a Service Broker/Database Mirroring transport operation. SNI error '10065(error not found)'.

An error occurred in a Service Broker/Database Mirroring transport connection endpoint, Error: 8471, State: 2. (Near endpoint role: Initiator, far endpoint address: '10.248.95.4')

Everything was fine up until now, and as far as I know nothing has changed on the server. Does anyone know what's wrong?

P.S. The setup is three servers on different networks, and we are using certificates to link the servers up.

synchronising files/folders

Sun, 01 Nov 2009 16:33:58 Z

Hi

You may think this is the wrong place but I am not sure if I can do it with
sharepoint or even sql server but the system I have at the moment isn't
really working well.

We have a dedicated virtual server running our email and ftp service which
at the moment is a basic NAT for all users (5 users all over the UK). The
email/ftp server are working great however we share 'projects' with each
other and at times work on the same projects. we are trying to
share/synchronise currently around 25gig of mainly office files
(word/excell/access and photos mainly) within a project folder system.

At the moment I am relying on staff to synchronise themselves and each home
office have responsibility to invoice etc our clients. If they don't
synchronise immediately then others may duplicate the invoice number etc...

What I want to do is for a system (I suppose almost like IMAP on email) that
will allow us to also work 100% offline to run automatically either
periodically or live/pinging check to keep the files both sides upto date in
order that if I save a new invoice the dedicated server NAT is updated and
then as others 'ping' in they are automatically synchronised.

At the moment I am using a software called beyond compare, which is doing
its job and in theory I can automate it however its with little success as
its not smart to realise or highlight mismatches and if files are
deleted/moved old copies are recopied by others into the old place further
duplicating files or even worse the files being deleted.

Can this be done by something by MS such as sharepoint and/or sql? I dont
want to use a live service as it will be too slow and the amount of storage
is too large. I do have a ftp backup to another server for the 'database' of
files giving us grandfather/father/son backups.

Any suggestions would be helpful. Briefcase and autosync again havent been
successful as sometimes files dont sync properly or when off line become
unavailabe...

even if you know of 'non-ms' software any help would be appreciated...its
almost a file/folder version of exchange but more complicated than home
server etc...

My dedicated currently has web 2003 version and most laptops have vista home/ultimate

many thanks in advance

disk layout for sql 2008 database mirroring

Thu, 22 Oct 2009 11:44:33 Z

Guys I'm rolling out a SQL database server that will be used to back Sharepoint 2007. Right now I need some advice on my disk layout. I have two Dell servers that are configured a little differently in terms of storage. The principle server will be using a combination of local storage and san storage. I have to work with what I have the organization is currently all allocated on san storage it was like pulling teeth to even get what I have to work with now. My disk setup on the principle is as follows raid 1 for OS, raid 10 for logs, raid 10 fiber on san for high IO databases, raid 10 sata on san for content databases. My question in regards to the principle server is where should I place the temp db I thought about placing it on the fiber raid 10 which will be hosting my high IO Sharepoint SSP databases my only other choice is to move it to the raid 1 os partition which I’m sure you guys will be against. Now let’s talk about the mirror server it is not connected to the san it is all local 6 15k SAS drives. Now my question is the same do I put tempdb on the os partition or do I leave the os partition and use a single raid 10 for everything? Any help you can provide is much appreciated.

SQL Server 2008 mirroring options are greyed out

Mon, 26 Oct 2009 10:20:21 Z

I am running SQL Server 2008 x64 Enterprise on 2 machines and I am trying to set up a database mirror. I have completed the backup and restore including log but when I go into properties - mirroring, all options other than "configure security" are greyed out.

The issue is that I need to use IP address as the principle but the name is showing instead.

I have tried to script it, but as the action fails there is nothing in the script

Any help would be appreciated.

Database mirroring using SQL 2K5

Wed, 21 Oct 2009 14:15:47 Z

Can any one know me the best Server Configurations (including OS) to install and enable database mirroring using SQL 2005 Enterprise Ed?

Database Properties “Mirroring” and "Transaction Log Shipping" Pages Missing

Mon, 14 Sep 2009 11:32:52 Z

I am having a problem with one database on my SQL Server 2005 production server.

A number of databases are already set up for mirroring, however when I right click and go to properties in SSMS, on one particular database there is no "Mirroring" property page available.

I have done the normal tasks, such as setting Full Recovery model, running a full backup of the database and backing up the logs.

I can't see that this is a server specific issue as other databases are happily mirroring.

I've looked around and I can't see that I'm missing a setting, any help would be appreciated.

Thanks.

EDIT: This is nothing to do with the Mirror Database yet, I can't get as far as specifying the Mirror Database , I cannot see the "Mirroring" page on the principle.

EDIT: I have managed to setup mirroring using t-sql commands. However I am still unable to see the "Mirroring Page".

UPDATE: This applies to the Transaction Log Shipping option as well. I can successfully set it up in SQL but not through SSMS.

Insufficient Log Data

Fri, 14 Apr 2006 15:41:52 Z

The mirror database, "UOP_PIMB", has insufficient transaction log data to preserve the log backup chain of the principal database. This may happen if a log backup from the principal database has not been taken or has not been restored on the mirror database. (Microsoft SQL Server, Error: 1478)

I've taken a backup while the database is online and applied it to my "other" server. What do I need to do to have both in sync to get mirroring to work. My way around this is to restore the backup to my primary.

thanks.

Insufficient Memory error after enabling mirroring.

Thu, 15 Oct 2009 01:56:10 Z

I have successfully mirrored most of our databases across two servers without a witness but when adding the last few I get the following error constantly:
There is insufficient system memory in resource pool 'internal' to run this query.
This error is generated by the secondary server. I have looked at the memory allocated and found it to be more than sufficient.
The only way to stop the error from occuring is to stop the SQL service and start it again.
I am running SQL Server 2008 Standard on windows server 2003 x86, the server is running 4GB Ram.
I have tried activating AWE but when I try to add the MSSQLSRV account to the 'Lock Pages In Memory' I find that the 'Add user or Group' button is greyed out. (I have administrator permissions and am accessing the server through remote desktop).
The following is the result of a memory consumption report.
Any Ideas?

	Memory Usage By Components
Component Type		Allocated memory(KB)	Virtual Memory Reserved(KB)	Virtual Memory Committed(KB)	AWE Memory Allocated(KB)	Shared Memory Reserved(KB)	Shared Memory Committed(KB)
MEMORYCLERK_SQLUTILITIES		80,144	133,336	133,336	0	0	0
MEMORYCLERK_SOSNODE		11,336	0	0	0	0	0
MEMORYCLERK_SQLSTORENG		6,776	2,624	2,624	0	0	0
MEMORYCLERK_SQLGENERAL		4,520	0	0	0	0	0
USERSTORE_OBJPERM		3,024	0	0	0	0	0
USERSTORE_SCHEMAMGR		1,536	0	0	0	0	0
OBJECTSTORE_SNI_PACKET		1,288	0	0	0	0	0
CACHESTORE_SQLCP		864	0	0	0	0	0
MEMORYCLERK_SQLCONNECTIONPOOL		816	0	0	0	0	0
USERSTORE_DBMETADATA		688	0	0	0	0	0
CACHESTORE_SYSTEMROWSET		520	0	0	0	0	0
MEMORYCLERK_SQLSERVICEBROKER		520	0	0	0	0	0
MEMORYCLERK_SQLBUFFERPOOL		504	1,654,240	29,248	0	0	0
OBJECTSTORE_SERVICE_BROKER		408	0	0	0	0	0
USERSTORE_TOKENPERM		320	0	0	0	0	0
OBJECTSTORE_LOCK_MANAGER		312	1,024	1,024	0	0	0
MEMORYCLERK_XE_BUFFER		0	4,224	4,224	0	0	0
MEMORYCLERK_FULLTEXT_SHMEM		0	0	0	0	192	192

why setup database mirroring in cluster environment

Mon, 19 May 2008 16:49:18 Z

Two technique are both designed to increase the availability of database.

And the difference is one is server level and other one is database level.

And i don't know why setup database mirroring in cluster environment, is there some complementary ?

any suggestions would be appreciated

Login failed database mirroring from application

Fri, 16 Oct 2009 21:45:47 Z

I have database mirroring set up on server A and Server B(sql 2005 sp3-9.0.4035)
the database is principal on server- A and
the database is mirror on server- B.
We have one user 'test' with same SID on both servers.

This 'test' user tries to connect to principal database
from ADO.NET application.
In the DSN file we have server A as principal

from the front-end the process runs fine but it gives error saying
'the server is not responding, try to connect to server failed.'
when i check error log files on sql server i cant see any error msgs
but i opened error log files on mirror server-B, I can see this error
Error: 18456, Severity: 14, State: 16.
Login failed for user 'test' [Client : 192.168.1.XXX]

I search on state-16 but name of the db in DSN is correct and we didnt specify failover
partner name in our DSN then why its going to server-B(mirror) and try to connect?
How can I stop this problem?

management agents

Tue, 13 Oct 2009 20:59:13 Z

we can configure Oracle Enterprise Manager10g to monitor and
manage our database and ther are two ways to do it :
1- we can centrally manage all our databases from a single management console by usin the Oracle Enterprise Manager Grid Controle if the Management Agent is installed on the database server, or

2- we can manage each database individually by using Oracle Enterprise Manager Database Controle.

and in the two ways we must start magemant agent

* for the first one we use /u01/app/oracle/product/10.0.1/bin> emctl start agent

* for the second we use /u01/app/oracle/product/10.0.1/bin> emctl start dbconsole

where is my problem,so

the problem : * I can 't understand the difference between the two ways, and with the existe of the Grid Controle, whay we have need to the second ways?

thank you,

Switching Back principal and mirror after failover

Tue, 28 Jul 2009 09:53:47 Z

hi,

I've setup a database mirroring with a principal, mirror and a witness.

When the principal loses connection, the mirror successfully becomes available, as it should be.

When the principal restores the connection, it becomes the mirror.

What I would like to happen is that when the original principal comes back online, it will become available and a principal and the mirror (which was the principal while the original one was offline) will become the mirror again.

Is that possible ?

Thanks.

Dror Yitzhakov.

quick question...Is it possible: SQL Enterprise Principal with a SQL Std Mirror...

Wed, 14 Oct 2009 18:07:45 Z

Hello, all. I was wondering if its possible to have a SQL Enterprise 2005/2008 Principal with a SQL Standard 2005/2008 Mirror. Is this possible? In either scenario both principal and mirror will both be on the same version...2005 or 2008.

Thnx
Roz

Database mirroring is suspended

Tue, 13 Oct 2009 05:52:47 Z

Database mirroring for one of the database is suspended, when I try to resume it again suspends. I have checked the SQL log in the Mirror server. I could also see some stack dump messages in sql log. Is this a bug ? This has been working for last 8 months without issues.

Env: SQL 2005 SP2+Hotfix (9.00.3159) 64 Bit EE

Excerpts from SQL Log:

While acting as a mirroring partner for database 'MOSS_SSP_SG-PROD-MOSS_StandardSSP1_Search', server instance 'SINSHPDBP3701' encountered error 3624, status 1, severity 20. Database mirroring will be suspended. Try to resolve the error and resume mirroring.

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.

SQL Server Assertion: File: <loglock.cpp>, line=818 Failed Assertion = 'result == LCK_OK'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

ERROR While Connecting to Mirror DB

Thu, 08 Oct 2009 10:37:54 Z

Dear all,

This is george, am new to this forum. I am submitting the error while trying DB MIRRORING. kindly help me with your suggestions.

When i am try to Create a Mirroring Session, the following is the error message, i am getting.

I really followed Mr.Kelo's instructions to create End Points and Started and Setting up Listenig port, But while giving the following command i am getting the error like below.

Query Executed on Principal Server:

ALTER

DATABASE DB_MIRROR

SET

PARTNER ='TCP://EAPL:5023'

where DB_MIRROR = Database Name; EAPL=Machine Name

THE ERROR MESSAGE I AM GETTING IS,

Msg 1418, Level 16, State 1, Line 1

The server network address "TCP://EAPL:5023" can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

I dont know where will be the problem, I have tried with UI also. I am getting same error. Kindly tell me How to check the Network addressname and Ports for Local and remote endpoints are operational.

Kindly help me in this issue,

Thanks and Regards,

x.george

"Bypassing recovery for database 'XXXX' because it is marked as an inaccessible database mirroring database. A problem exists with the mirroring session.

Tue, 29 Sep 2009 16:14:53 Z

SQL Server info SQL Server Std edition SP3 on both Principal and Mirror X64. SQL Server Express edition Sp3 on witness x64 WOW.
OS Info Server 2003 X64 Std Edition SP2

Succesfully setup mirroring using certificates on database X. Mirror monitor indicated asll communication green and in sync. SQL Server X on Host X where database X was principal we restarted. Database X failed over to SQL Server Y on Host Y. All in sync and all communication green per Mirror Monitor.
Database X failed back to SQL Server X using Alter database 'X' set partner failover. Database never comes out of recovery.
"Bypassing recovery for database 'X because it is marked as an inaccessible database mirroring database. A problem exists with the mirroring session. The session either lacks a quorum or the communications links are broken because of problems with links, endpoint configuration, or permissions (for the server account or security certificate). To gain access to the database, figure out what has changed in the session configuration and undo the change.
To my knowledge noithign was changed (of course). But I verified existence of logins and users, logins permissions on endpoints, endpoints existed and started. Could ping between all hosts. Ended up having to break the mirror from SQL Server Y. Could not break mirror from SQL Server X. Could not failback from SQL Server X or Y. Ran DBCC checkdb and no errrors.
Looking for any information on this error or any ideas of addtional troubleshooting that could be done.
TIA,

sql server 2005

Sat, 10 Oct 2009 10:45:46 Z

how to create employee details table in sql server 2005

Reporting off of a Database Mirror SQL Server 2008

Mon, 12 Oct 2009 12:57:53 Z

Hi guys,

I have databases mirroring running on one server. The databases are cross join. I created snapshot for the reporting. The problem I found I cannot just drop the snapshot and create new one because may be some client might selecting something data from the snapshot at that time.

So I found I faced two problems

1- Cross database join. I thought I can solve it by dynamic SQL after getting the latest snapshot from the sys.databases

2- The data source in the report need to be dynamic to connect to the latest snapshot. I was hoping I can connect to master database and get the latest snapshot and make my Initial Catalog but I couldn’t get the source code

Can you please advise me how to make it work?

Thank you

Login failed for user. Cannot open database message for linked server to mirrored partners

Fri, 09 Oct 2009 20:33:10 Z

I have a linked server connection to a mirrored pair of servers. When it connected to principal, it has no problems. However, if I manually fail it over to the partner I get an error "Login failed for user <user_name>. Cannot open database <mirrored_database_name>".

It happens only with first execution. With all the rest executions it runs fine. Same thing happens when I fail it back to original principal, for first execution I receive an error, however with all the rest executions it runs fine again.

My connection string looks like "SERVER=<SERVER\INSTANCE,PORT#>;DATABASENAME=<DBNAME>;FailoverPartner=<SERVER\INSTANCE,PORT#>';User ID=<USER>"

Replicating sql 2005 database with compatibility level 70

Wed, 04 Jun 2008 18:29:39 Z

I'm trying to replicated a database with compatibility level 70 on sql server 2005, but the system is unable to create a snapshot.

Error messages:

Message: metadata query failed
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.WorkerThread.AgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Get help: http://help/0

Message: Incorrect syntax near 'collate'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
Stack: (Source: MSSQLServer, Error number: 325)
Get help: http://help/325

If i change the compatibility level to 90 every thing works fine, but the client software demands that the database is on compatibility level 70.

Any solutions ??

Thanks, Iwan

Shared hosting and accessing multiple databases

Thu, 08 Oct 2009 22:48:55 Z

Hi there,

I have a shared hosting plan, and that hosting has 3 databases (each 250MB space) I asked the admin if they could join those databases together so I would have one 750Mb database but they told me that they won't do it because of maintainance difficulties.

So my question is:

Can I create 3 db's and then access all of them in one stored procedures? - can I access db2 from stored procedure that is located in db1?

I mean, when I create 3 db's on my local machine I can then query those db's like this:

select * from [Database ].[Schema].[Customer] as customer
join [Database2 ].[Schema].[CustomerInfo] ... the rest of code ...

But I on my local machine I use Windows authentication, so, this is easy. On hosting, each db has it unique User Name and password. So, I feel that on shared hosting it will be at least tricky or even impossible.

Could someone please point me to some resources on how to do this task? (Assuming it is possible).

I was thinking that I place some tables to db1 others to db2 and in the application I will use different connection string for certain tasks, but that is not possible because those table are linked together and I have to do some joins on them. I would like to make this somehow possible because it would be really a waste of space to buy better hosting plan with bigger db when I have already 2 db's that I can't use :(

Any help, or any suggestion would be really appreciaeted.
Thanks guys.

--edit: Oh I'm sorry I saved it to wrong category and don't know how to change it :(

Database Mirroring question? SQL 2005 SP3

Thu, 08 Oct 2009 20:11:48 Z

I have a problem and can seem to find the correct path to setup mirroring on Windows Server R2 SP2 running SQL 2005 sp3.

1. I have my main server PVSSQL database name : PVS1
    a. Here are the steps------>Backup The Database: Worked
    b. Back up Trans log---------> OK!

2. Copyed the backup from PVSSQL to PVSSQL2
    a. I did a restore of database PVS1 on the backup server PVSSQL2---------> NORECOVERY
    b. same steps for the trans log------------> NORECOVERY

So far these steps seem to work fine no problem.

Here is I'm stuck at and can't seem to find out what I have done incorrect.

I can't find the configure database mirroring

when I go back on the main server to setup the database for mirroring I can find the " configure database mirroring security wizard "

I'm a SQL admin so if missed any steps please let me know

Any help would be great

-Ed