Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

configuring database mirroring first time ...please help me..urgent Expand / Collapse
Author
Message
Posted Friday, July 30, 2010 3:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, July 30, 2010 3:44 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 12:34 AM
Points: 188, 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
Post #961207
Posted Friday, July 30, 2010 3:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, July 30, 2010 4:05 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 12:34 AM
Points: 188, 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
Post #961219
Posted Friday, July 30, 2010 4:07 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 12:34 AM
Points: 188, 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
Post #961220
Posted Friday, July 30, 2010 6:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, July 30, 2010 6:45 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 12:34 AM
Points: 188, 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
Post #961306
Posted Friday, July 30, 2010 7:16 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, July 30, 2010 7:24 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 27, 2013 12:34 AM
Points: 188, 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
Post #961352
Posted Friday, July 30, 2010 7:33 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:09 AM
Points: 6,735, Visits: 8,495
... 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


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

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


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #961361
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse