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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » configuring database mirroring first time...

20 posts, Page 1 of 2

1 2 »»

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

Rate Topic

Display Mode

Topic Options

Author

Message

rishi anjali

Posted Friday, July 30, 2010 3:32 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 15, 2010 6:51 AM
Points: 22, 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

Post #961205

Sudeepta

Posted Friday, July 30, 2010 3:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 10, 2012 5:19 AM
Points: 188, Visits: 188

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

Post #961207

rishi anjali

Posted Friday, July 30, 2010 3:51 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 15, 2010 6:51 AM
Points: 22, 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).

Post #961212

Sudeepta

Posted Friday, July 30, 2010 4:05 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 10, 2012 5:19 AM
Points: 188, Visits: 188

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

Post #961219

Sudeepta

Posted Friday, July 30, 2010 4:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 10, 2012 5:19 AM
Points: 188, Visits: 188

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

Post #961220

rishi anjali

Posted Friday, July 30, 2010 6:42 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 15, 2010 6:51 AM
Points: 22, Visits: 61

thanks

in this case we should create new end point or we can configure with default endpoint(5022).

Post #961301

Sudeepta

Posted Friday, July 30, 2010 6:45 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 10, 2012 5:19 AM
Points: 188, Visits: 188

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

Post #961306

rishi anjali

Posted Friday, July 30, 2010 7:16 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 15, 2010 6:51 AM
Points: 22, 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

Post #961341

Sudeepta

Posted Friday, July 30, 2010 7:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, February 10, 2012 5:19 AM
Points: 188, Visits: 188

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

Post #961352

ALZDBA

Posted Friday, July 30, 2010 7:33 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:25 AM
Points: 6,861, Visits: 8,045

... 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

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't 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" BigGrin

Need a bit of Powershell? How about this

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

Post #961361

« Prev Topic | Next Topic »

20 posts, Page 1 of 2

1 2 »»

Permissions