Mirroring Connection Problem

Oct 23, 2007



Greetings,
I am trying to setup database mirroring on two seperate servers running SQL 2005 SP2. I would eventually like to add a witness. I have tried the SQL wizard with and without a witness to no avail. I am now trying to use certificates. I have changed both servers to use a domain administrator logon to run the services. I am getting the following message each time I try to alter the database on the principal after I have setup everything on the mirror server.
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://10.99.99.02:5022" 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.

Here is the TSQL statements I am using on the principal server:
-- Step 1
create master key encryption by password = 'xxxxxx'

-- Step2
create certificate Principal_Cert
with subject = 'Principal Certificate',
expiry_date = '12/31/9999'

--Step 3
backup certificate Principal_Cert to file = 'c:Principal_cert.cer'

--Step4
create endpoint Endpoint_Mirroring
state = started
as TCP (listener_port = 5022, listener_ip = all)
for database_mirroring (authentication = certificate Principal_Cert,
encryption = required algorithm AES,
role = all)

-- Backup database SPOT - go to Mirror Server

-- Step 5 after setup on Mirror server

create login Mirror_login with password = 'xxxxxxxx'

-- Step 6
create user Mirror_user for login Mirror_login

--Step 7
create certificate Mirror_Cert
authorization Mirror_user
from file = 'c:Mirror_cert.cer'

--Step 8
use master
grant connect on endpoint::Endpoint_Mirroring to [Mirror_login]

-- Step 9
alter database spot
set partner = 'TCP://10.99.99.02:5022'

**** Getting message here **********

-- Checks

select * from sys.server_principals

select * from sys.sysusers

select * from sys.certificates

select * from sys.database_mirroring_endpoints

SELECT e.name, e.protocol_desc, e.type_desc, e.role_desc, e.state_desc,
t.port, e.is_encryption_enabled, e.encryption_algorithm_desc,
e.connection_auth_desc
FROM sys.database_mirroring_endpoints e JOIN sys.tcp_endpoints t
ON e.endpoint_id = t.endpoint_id

Here is the TSQL statements I am using on the mirror server. This all works fine.

-- Step 1
create master key encryption by password = 'xxxxxxxx'

-- Step2
create certificate Mirror_Cert
authorization dbo
with subject = 'Principal Certificate',
EXPIRY_DATE = '12/31/9999'
ACTIVE FOR BEGIN_DIALOG = ON

--Step 3
backup certificate Mirror_Cert to file = 'c:Mirror_cert.cer'

--Step4
create endpoint Endpoint_Mirroring
state = started
as TCP (listener_port = 5022, listener_ip = all)
for database_mirroring (authentication = certificate Mirror_Cert,
encryption = required algorithm AES,
role = all)

-- Step 5

create login Principal_login with password = 'xxxxxxxx'

-- Step 6
create user Principal_user for login Principal_login

--Step 7
create certificate Principal_Cert
authorization Principal_user
from file = 'c:Principal_cert.cer'
ACTIVE FOR BEGIN_DIALOG = ON

--Step 8
use master
grant connect on endpoint::Endpoint_Mirroring to [Principal_login]

-- Restore Step

RESTORE DATABASE SPOT
FROM DISK = 'C:SPOT.bak'
WITH NORECOVERY

RESTORE log SPOT
FROM DISK = 'C:SPOT_log.bak'
WITH NORECOVERY

-- Step 9
alter database spot
set partner = 'TCP://10.99.99.01:5022'

-- Checks

select * from sys.server_principals

select * from sys.sysusers

select * from sys.certificates

select * from sys.database_mirroring_endpoints

SELECT e.name, e.protocol_desc, e.type_desc, e.role_desc, e.state_desc,
t.port, e.is_encryption_enabled, e.encryption_algorithm_desc,
e.connection_auth_desc
FROM sys.database_mirroring_endpoints e JOIN sys.tcp_endpoints t
ON e.endpoint_id = t.endpoint_id

select *
FROM sys.database_mirroring_endpoints


Does anyone have any ideas?

Thanks

View 3 Replies


ADVERTISEMENT

Db Mirroring Connection Problem

Apr 29, 2008

Hi all,

I am trying to set up db mirroring between 2 servers and I have everything pretty much set but only problem so far is connecting to mirrored server. When I go through the "Configure Security" setup I connect to the mirrored server using server name "sqlsvr2" and user/password that has access to the endpoint. After this is finished it automatically enters TCP://sqlsvr2:5022 in to the address bar, which it doesn't like, so I change it to TCP://sqlsvr2.domain.com:5022 but then I get no connection when I try to start the mirror. sqlsvr2.domain.com pings just fine and also responds to telnet on port 5022. I even tried using the IP address for tcp connection but it's not connecting.
What am I missing here?

View 5 Replies View Related

Mirroring Connection Time Out

Apr 2, 2008



Hi,
I have Mirroring setup for 3 databases without a witness.
The database mirroring monitor shows me that both Principal and Mirror are "Synchronized".
SSMS also shows that the both instances are "Synchronized".

However, the following error message appears couple of times in the event viewer:
The mirroring connection to "TCP://abc.xyz.com:5022" has timed out for database "DB" after 10 seconds without a response. Check the service and network connections.

Also came across this article.
http://support.microsoft.com/kb/947462

Should i be worried?


thanks

View 9 Replies View Related

Connection String For Mirroring Db In Tomcat

Nov 21, 2007

hi all,

I 've done the mirroring in sql server 2005 sp1 now I 've to write the connection string for partner and failover server in tomcat root.xml file anyone know how to write the connectionstring?

my normal connection related stuffs which I am writing in root.xml is

<!-- SQL Server -->

<Resource
name="jdbc/LiferayPool"
auth="Container"
type="javax.sql.DataSource"
driverClassName="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtdsqlserver://localhost:1433/normal_db"
username="sa"
password="ok"
maxActive="20"
/>

View 2 Replies View Related

Database Mirroring Connection Errors

Apr 24, 2007

I'm currently using database mirroring as a hot-standby, without a witness. Everything appears to be running fine, but I'm receiving intermittent errors that appear to state that my servers are loosing connectivity, thus disabling (inactivating) the mirror until the connection has been reestablished.



The errors are listed below, basically, I note a block of log entries for each mirrored database stating that mirroring is inactive for the database(s), next Error 1474, next the connection error, then another block of log entries for each mirrored database stating that the mirroring session is once again active.



Database mirroring is inactive for database 'NetRS'. This is an informational message only. No user action is required.

Error: 1474, Severity: 16, State: 1.

Database mirroring connection error 4 '64(The specified network name is no longer available.)' for 'TCP://SQL01NRS:7024'.

Database mirroring is active with database 'Telephony' as the principal copy. This is an informational message only. No user action is required.



I have confirmed that the sessions are in sync, so am not concerned about the data - but would love to get rid of these errors / disable / enable. I'm assumming that if I had setup a Witness, that I would see the mirrored database flip-flopping back and forth between Principal and Mirror.



Please let me know if I can provide any additional details to assist ...

View 5 Replies View Related

Mirroring :: Server Connection String

Sep 8, 2015

I develop a website. When I work in local machine for login/logout, The connectionstring works well.

<add name="DefaultConnection" connectionString="Data Source=(LocalDb)v11.0;AttachDbFilename=|DataDirectory|xxxxx.mdf;Initial Catalog=Restaurants;Integrated Security=True" providerName="System.Data.SqlClient" />

But When I deploy the web to IIS server. The I always can't work normally. The system cannot find the file specified..An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ComponentModel.Win32Exception: The system cannot find the file specified

Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

[Win32Exception (0x80004005): The system cannot find the file specified].[SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 52 - Unable to locate a Local Database Runtime installation. Verify that SQL Server Express is properly installed and that the Local Database Runtime feature is enabled.)]

View 5 Replies View Related

Problems On Connection During Mirroring (Error 1418)

Nov 3, 2006

Hi everyone, I am a newbie on setting up database mirroring and right now I am facing the connection problem during mirroring which is Error 1418 which kinda common problem. I just view through all the threads regarding this problems and BOL also. However, I just based on all the guide to setting it up and the result are still the same.

I did tried on both instance names in my server for mirroring and displayed the same results as well. When I type this t-sql on mirror server :

ALTER DATABASE AdventureWorks SET PARTNER = 'TCP://TSUYOSHI:5022' -- which is the principal server

It shows connection ok to me. However, when I type this t-sql on the principal server :

ALTER DATABASE AdventureWorks SET PARTNER = 'TCP://HAN:5023' -- which is the Mirror server

It shows connection ok to me. However, when I type this t-sql on the principal server :

Msg 1418, Level 16, State 1, Line 1

The server network address "TCP://HAN: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 just wondering that why mirror can get a connection to principal but principal can't? Is that any extra configuration especially security settings that needed to be set within the database (MS sql server 2005) ?

I hope I am able to get any assistance from anyone at here and will appreciate on it. Thanx. Anyway, sorry for the inconvenience

Best Regards,

Hans

View 11 Replies View Related

SQL Server Admin 2014 :: Database Mirroring Connection Handshake Failed

May 9, 2015

I configured a database mirroring on SQL server 2008 R2 on test environment. However It was not working, after some time. I deleted the mirroring configuration and also deleted database on both primary and mirror instance.

few days later I notices, On Primary, Continuous error events logged with message "database mirroring attempt by user 'domainservice account' failed with error 'connection handshake failed, 'domainservice account' does not have permission on the endpoint state 84.

I want to get rid of this message.

View 2 Replies View Related

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

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

Mirroring :: Setting Up Mirroring With Different Vlans?

Sep 15, 2015

I need to set up asyncronous data replication across two clustered instances of SQL 2012 across 2 Datacenters. Both the datacenters have a common domain however the vlans are different. There are only 3 small databases on the primary instance.

any issue in setting up mirroring in this case as vlans are different.

Operating system is Windows 2012.

View 2 Replies View Related

Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object

Aug 23, 2006

I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

View 2 Replies View Related

Failed OLEDB Connection: Cannot Aquire Connection From Connection Manager

Feb 6, 2008

I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.

Thanks,

John T

View 3 Replies View Related

Mirroring

Mar 7, 2000

Hi All
By mirroring I mean device mirror, since I do not think that there is a database mirror
We only have disk mirror. I also know that SQLServer 7.0 does not provide Mirror, unmirror or remirror. and for this we have to refer to Windows NT disk mirroring.
I need mirroring in both versions SQL Server 6.5 and 7.0

I want to have mirror on another server. I need this for tonight.
Sincerely.

View 1 Replies View Related

Help Need For Mirroring

Apr 1, 2008

I hereby let u know the steps that i undertook for performing mirroring



1. Created a database in Principal server named Mirror1 and one table named tblMirror1.( no values inside the table)

2. Repeated the same in Mirror in Witness

3. Selected the Principal server's database -->right click-->tasks-->mirror

4. from the left hand panel selected Options -->recovery model-->full

5. selected Mirroring from left hand panel-->configure secuirty-->entered mirror and witness name--Success



6. When I click on start mirroring I have an error stating

" Alter failed for database mirror1"

"Database mirroring cannot be enabled because Mirror1 database may have bulk logged changes that have not been backed up etc...."




7. followed this one
BACKUP database mirror1 TO DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'

got the answer as

Processed 160 pages for database 'mirror1', file 'Mirror1' on file 2.
Processed 1 pages for database 'mirror1', file 'Mirror1_log' on file 2.
BACKUP DATABASE successfully processed 161 pages in 0.318 seconds (4.147 MB/sec).

According to sources
Run a restore of this backup on your mirror.
This can be done through the GUI or using a T-SQL command.

The database restore must use the NO RECOVERY option, so the database stays in a loading state.

Also the database name on the mirror must be the exact same name as the principal

RESTORE TestMirror FROM DISK='C:Backup TestMirror_FULL.BAK' WITH NORECOVERY



Hence did the below


RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY

ERROR

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.


HENCE MODIFIED AS

use master
go
RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

========

Kindly let me know please where am i going wrong

Regards
cmrhema

View 1 Replies View Related

Db Mirroring

Mar 13, 2007

hello

if i run dbcc dbreindex on a database thats the principal in a mirrored pair, will the mirrored database indexes also be rebuilt?

View 1 Replies View Related

Db Mirroring

Mar 27, 2007

i am for the first time creating the database mirroring.I am moving the all the usr databases and everything from test server to a new server called test1.And from that new server i am restoring on the another new server called test2 for database mirroring.But in the test server , the transaction logs are backup for every 15 minutes.So in this case is there a need to move all the logs to test1 and then to test2 for mirroring?? or there is no need to move transaction logs to the new servers at all??


my secnario
------------
server1 server2 server3
-------- ------- --------
test test1 (moving everything from test) test2(mirror for test1 )

all the transaction logs are backup in test for every 15 minutes. so in this case , do i need to move the transcation logs from test to test1 and test2
or there is not need to move at all??


thanks,

View 1 Replies View Related

Mirroring

Nov 7, 2007

Can anyone please tell me what mirroring is??



Thanks in ADvance

RKNAIR

View 2 Replies View Related

Mirroring

Jan 30, 2008

I have sql server 2005 on my vista laptop.

When i set up database mirroring, do i have to set up Principle,
mirror and witness on seperate servers as well as seperate instances.

Or can i install 3 seperate instances on the same laptop im using and still use mirroring? I have tried to start mirroring with all three instances on my laptop but i receive an error.

Regards

Rob

View 1 Replies View Related

Mirroring

Mar 26, 2008

Hi All,

I am trying to set up database mirroring and in the initial phase of database restoring im getting some problem.

the scenario is .

1- I create a TestMirror on server1(which will be principal server) and backup full and transaction logs.

2- create TestMirror in server 2( Which is going to be used as mirror) .

3- restore the full backup of "TestMirror" from Principle Sever with NORECOVERY option.



this step results in a message box showing that the restore was successfull...

but the database explorer( management studio) shows the TestMirror in (restoring ...) state. and no more operations can be performed with this Database. ( because the database is in restoring mode).. please help what this issue is?



Thanks In Advance for any suggestions
-- Krishna

View 9 Replies View Related

Mirroring

May 6, 2007





hello

i used following query to create endpoint



CREATE ENDPOINT Endpoint_Mirroring

STATE = STARTED

AS TCP (

LISTENER_PORT=5024

, LISTENER_IP = ALL

)

FOR DATABASE_MIRRORING (

AUTHENTICATION = CERTIFICATE HOST_A_cert

, ENCRYPTION = REQUIRED ALGORITHM RC4

, ROLE = ALL

);

GO



i got the following error msg:



Msg 1498, Level 16, State 2, Line 11

Database mirroring is disabled by default. Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments. To enable database mirroring for evaluation purposes, use trace flag 1400 during startup. For more information about trace flags and startup options, see SQL Server Books Online.





any help plzz



thanks in advance

View 3 Replies View Related

Mirroring

Aug 22, 2007

Hello,
I have Microsoft SQL SERVER 2005 installed in my system.
To try out mirroring, I rightclicked on the database went to the tasks, but i found that in Status its written

"This database has not been configured for mirroring"


What shall I do now?

View 5 Replies View Related

DB Mirroring On VHD's

Oct 22, 2007



Hi,

I am new to DB mirroring and witness. For the purpose of learning, any one can suggest me like is there any posibility to do the DB mirroring and witness on 2 or 3 VHD Files. Basically, these VHD's are downloaded from microsoft website.



VHD's have W2K3 and SQL2K5 EE .

Please suggest me in this.

Regards,
Mohanraj Jayaraman



View 3 Replies View Related

SQL Mirroring

Nov 10, 2006

Hello Guys,

Can any one help I want SQL to email me when a database fails over I can find alerts for loads of thing to do with Mirroring but not to notify me when a database failover.



Thanks matt

View 1 Replies View Related

Mirroring Big Transaction

Nov 23, 2006

How sql server will mirror big transaction ?

Example

inserting 10000000 rows in 1 transaction (columns big ,text data ...)

will it transfer data in multiple packets (size, location of temp file) to mirror ?

will it transfer data in 1 packet (size , location of temp file ) to mirror ?

Can you control transfer (size , location of temp file) ?

Thanks

Alex

View 1 Replies View Related

Sql Server Mirroring

Sep 28, 1998

Do you know if the following excerpt from technet is still true? I want to mirror a device over the net to another server. Has anyone tried this with sql server 6.5 or is it still not a feature?
----------------------
PSS ID Number: Q115043
Article last modified on 04-29-1997
4.2 | 4.2
OS/2 WINDOWS


================================================== ====================
----------------------------------------------------------------------
The information in this article applies to:

- Microsoft SQL Server version 4.2 for OS/2
- Microsoft SQL Server version 4.2
----------------------------------------------------------------------

The use of database devices accessed over the network is not a supported
configuration for either the OS/2 or Windows NT versions of Microsoft SQL
Server. All database devices, including mirrors, should be configured to
use local drives. Database dump devices are an exception to this
restriction.
----------------
Thanks.
Gail Wade
Raymond James and Associates
Clearwater, FL
gwade@is.rjf.com

View 1 Replies View Related

Mirroring Confusion.

Aug 10, 2006

I am testing out Synchronous Mirroring and have a question about failover. It seems the only way I can failover to the Mirror box is to log onto the Principal box and hit the Failover button? Is the whole point of mirroring to be able to handle the Principal not being available? Is there another way?

TIA, ChrisR

View 4 Replies View Related

Database Mirroring

Oct 12, 2007

Hi All,

Does anybody know the OS requirements for Database Mirroring? I checked BOL and Google but couldn't find any info on that.

Thanks.

View 5 Replies View Related

Database Mirroring

Feb 27, 2008

Hi All,

I have read on the web that high protection mode not recommended, except in the event of replacing the existing witness server. But I can't find the reason why anywhere. Can anybody explain? Thanks.

View 2 Replies View Related

Database Mirroring

Mar 12, 2008

Hi All,

Couple of questions about database mirroing.

1. Once the mirroring is setup is it possible to switch between high-protection and high-performance modes? If it is will I have to stop the mirroring, switch the modes and then restart it again?

2. Let's say the principal server went down and I manually failed over to the mirror server. Mirror server runs as a new principal server for a couple of days and then I bring the original principal server back up. What needs to be done in order to bring transactions on the principal server up to date?

Thanks.

View 1 Replies View Related

Cannot Implement Mirroring

Apr 1, 2008

Hi,

I have place an question, but in some other place in the same forum.

My apologies for that



I wanted to implement mirroring
I hereby let u know the steps



1. Created a database in Principal server named Mirror1 and one table named tblMirror1.( no values inside the table)

2. Repeated the same in Mirror in Witness

3. Selected the Principal server's database -->right click-->tasks-->mirror

4. from the left hand panel selected Options -->recovery model-->full

5. selected Mirroring from left hand panel-->configure secuirty-->entered mirror and witness name--Success



6. When I click on start mirroring I have an error stating

" Alter failed for database mirror1"

"Database mirroring cannot be enabled because Mirror1 database may have bulk logged changes that have not been backed up etc...."




7. followed this one
BACKUP database mirror1 TO DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'

got the answer as

Processed 160 pages for database 'mirror1', file 'Mirror1' on file 2.
Processed 1 pages for database 'mirror1', file 'Mirror1_log' on file 2.
BACKUP DATABASE successfully processed 161 pages in 0.318 seconds (4.147 MB/sec).

According to sources
Run a restore of this backup on your mirror.
This can be done through the GUI or using a T-SQL command.

The database restore must use the NO RECOVERY option, so the database stays in a loading state.

Also the database name on the mirror must be the exact same name as the principal

RESTORE TestMirror FROM DISK='C:Backup TestMirror_FULL.BAK' WITH NORECOVERY



Hence did the below


RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY

ERROR

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.


HENCE MODIFIED AS

use master
go
RESTORE database mirror1 FROM DISK='C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK' WITH NORECOVERY

Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupmirror1_FULL.BAK'. Operating system error 2(The system cannot find the file specified.).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.



Please let me know what shuld i modify

regards
cmrhema

View 20 Replies View Related

Mirroring & Snapshots?

May 16, 2008

I think I've read some conflicting advice in BOL. Maybe someone can clarify it for me.

Under "Database Mirroring and Database Snapshots" it says:
"You can take advantage of a mirror database that you are maintaining for availability purposes to offload reporting. To use a mirror database for reporting, you can create a database snapshots on the mirror database and direct client connection requests to the most recent snapshot"

To my mind, to enjoy a noteworthy performance gain, that mirror database would need to be on another server.

But then you read under "Database Snapshots":
"Multiple snapshots can exist on a source database and always reside on the same server instance as the database."

So how do you get the snapshot to the mirror?

View 2 Replies View Related

Mirroring Question

Jun 5, 2008

I have a quick question regarding mirroring failover. If you have mirroring setup with a witness and the principal server goes down, once the principal is back up as the mirror will it automatically synchronize with the new Principal?

The main thing that I wasn't sure of is that if it took a fair amount of time to bring the original principal back up, the new principal will be in production so will all the new transactions be sent to the mirror once it is available?

View 1 Replies View Related







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