SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


configuring database mirroring first time ...please help me..urgent


configuring database mirroring first time ...please help me..urgent

Author
Message
rishi anjali
rishi anjali
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 61
hi all,
im a sql dba.first time im cofiguring DATABASE MIRRORRING(sql server 2008)on our client severs .im the only one in my organization.no one is there to help.

what are the information i need to collect from the client to configure the mirroring.

Before starting the configuration wizard,what are all i need to check.
it could be help full if some one help me in this
Sudeepta
Sudeepta
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 Visits: 189
Here is a link for a step-by-step article on how to configure Database Mirroring using SQL Server 2008

You may need to check whether you need to configure database mirroring between stand-alone machines or in a cluster environment, whether an automatic failover is required or not. Also is the mirroring needs to configure between two different sites, if yes, then you may need to reconsider the operating modes as well.

Hope, this may help.

Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
rishi anjali
rishi anjali
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 61
i need to configure database mirroring between stand-alone machines.

we have two datacenters in different locations. and mode we have to configure is asynchronus(no automatic failover).
Sudeepta
Sudeepta
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 Visits: 189
If both your SQL instances are in a domain environment, then you can create a database mirroring operating in High Performance Mode (asynchronous data transfer). The above link will still holds good for your configuration, only you don't execute the code required for the witness server.

You also need to consider that while a database mirroring session operates in High Performance mode, a data loss can occur while you do a manual switch over. Also the mirror database may not contains the same data as principal database as there is no confirmation.

If your SQL Servers are in a workgroup environment, then you may need to consider using certificate for the database mirroring session.

Hope, this may help.

Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
Sudeepta
Sudeepta
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 Visits: 189
You may need to configure your firewall to open for the ports, that will be used for the database mirroring endpoints.

Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
rishi anjali
rishi anjali
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 61
thanks

in this case we should create new end point or we can configure with default endpoint(5022).
Sudeepta
Sudeepta
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 Visits: 189
I think you are talking about the port number. Yes, it is as per your choice/SLA. You can use the default port or change it to a custom port.

Database Mirroring endpoints are not created by default, you have to create it.

Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
rishi anjali
rishi anjali
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 61
My datacenters are in two different countries and they are in the same domain,is there any necessity of certificates.

if so could you help me in that.

thanks & regards
anjali
Sudeepta
Sudeepta
SSC Veteran
SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)SSC Veteran (266 reputation)

Group: General Forum Members
Points: 266 Visits: 189
No, since both are in the same domain, you can configured it without certificate.

Follow the steps from the article, I don't think you will have any issue during configuration.

Thanks & Regards,
Sudeepta.
http://twitter.com/skganguly
ALZDBA
ALZDBA
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16292 Visits: 8971
... help me ... urgent..


Wouldn't it be a wise idea to first test a little bit with the technology ?

- So you know how to:
* put in place
* monitor
* follow up
* troubleshoot
* handle failover
....

- So you can determine the usage mode based on sound knowledge and your companies need.

- Keep in mind your applications connections will need to be modified. They will have to use SQLNCLI !


Also keep in mind DBMirroring is not supported in all cases !!
http://technet.microsoft.com/en-us/library/ms366279.aspx


Database mirroring is not supported with either cross-database transactions or distributed transactions. This is because transaction atomicity/integrity cannot be guaranteed for the following reasons:

For cross-database transactions: After a failover, the mirrored database is on a different server instance, and typically it is on a separate database from the nonmirrored database. Even if both databases are mirrored between the same two partners, there is no guarantee that both databases will fail over at the same time.

For distributed transactions: After a failover, the new principal server is unable to connect to the distributed transaction coordinator of the previous principal server that uses the same resource ID. Therefore, the new principal server cannot obtain the transaction status.


Johan


Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


press F1 for solution, press shift+F1 for urgent solution :-D


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me Alien but most of the time this is me Hehe
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search