July 30, 2010 at 3:32 am
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
July 30, 2010 at 3:44 am
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
July 30, 2010 at 3:51 am
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).
July 30, 2010 at 4:05 am
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
July 30, 2010 at 4:07 am
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
July 30, 2010 at 6:42 am
thanks
in this case we should create new end point or we can configure with default endpoint(5022).
July 30, 2010 at 6:45 am
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
July 30, 2010 at 7:16 am
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
July 30, 2010 at 7:24 am
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
July 30, 2010 at 7:33 am
... 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
Learn to play, play to learn !
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[/url]
- 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
July 30, 2010 at 8:30 am
ok thank you
July 30, 2010 at 9:24 am
i configured database mirroring on local servers.and i have knowledge on this. however i am bit tense. why because first time configuring on the client machines.
so please help me
July 30, 2010 at 9:27 am
we have the login as sa.
how to create end point with sql authentication
July 30, 2010 at 10:04 am
Don't use 'sa' for ANY login !! This is a worst practise !
If this is within the same domain, just use a windows service account to configure the mirroring stuff.
Use regular (non-sysadmin) sqlusers or windows accounts with your application(s).
How to connect ?
have a look at http://www.connectionstrings.com/sql-server-2008
search on database mirroring.
Johan
Learn to play, play to learn !
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[/url]
- 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
July 31, 2010 at 11:36 am
the failover partner connection string parameter is only required if confuring automatic failover. You need to be using either the SQL native client or ADO.NET
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply