February 10, 2010 at 9:08 am
Have you created the database mirroring endpoints on the two servers?
Are you using NT Authentication or Certificates for the connection between the two servers?
Have you granted CONNECT permissions as needed to the database mirroring endpoints?
Have you ALTERed the databases to point the databases to their respective partners?
All I can see that you have done is restore the database to the secondary server. What you have done in that regard is correct, Full Backup + Transaction Log.
February 10, 2010 at 9:10 am
And yes, I am currently in the process of setting up database mirroring myself. There is actually quite a bit to do to get it up and running.
You should do some more reading in Books Online. As you work through the reading, ask questions. There are some other gotcha's that aren't readily apparent in the BOL documentation or else I just missed it.
February 10, 2010 at 9:14 am
You have to follow sequence in configuring the SQL Server Database Mirroring.
Full backup,
Trans backup,
Restore full backup on secondary with NORECOVERY,
Rectore Trans log backup on secondary with NORECOVERY,
Enable Trace flag ;-T1400,
end points,
configure.....
Hope these helps:
http://www.sqlserver.in/index.php/administration/48-database-mirroring/97-database-mirroring.html
http://www.codeproject.com/KB/database/sqlmirroring.aspx
http://msdn.microsoft.com/en-us/library/ms175059.aspx
Cheers,
- Win.
" Have a great day "
February 10, 2010 at 9:20 am
winslet (2/10/2010)
You have to follow sequence in configuring the SQL Server Database Mirroring.Full backup,
Trans backup,
Restore full backup on secondary with NORECOVERY,
Rectore Trans log backup on secondary with NORECOVERY,
Enable Trace flag ;-T1400,
end points,
configure.....
Hope these helps:
http://www.sqlserver.in/index.php/administration/48-database-mirroring/97-database-mirroring.html
I have database mirroring up and working, and did not need to enable trace flag 1400. I believe this was only needed when SQL Server 2005 was first released. It was activated in SP 1, iirc.
February 10, 2010 at 9:31 am
Correct.
If we have SP2 installed we dont require enabling trace flag 1400....
Cheers,
- Win.
" Have a great day "
February 10, 2010 at 9:33 am
Q-1>Have you created the database mirroring endpoints on the two servers?
Ans>No I did not, do I need to ?
Q-2>Are you using NT Authentication or Certificates for the connection between the two servers?
Ans> Yes, NT Authentication on both the instances on the same server
Q-3>Have you granted CONNECT permissions as needed to the database mirroring endpoints?
Ans> I have no clue about this, can you assist me.
Q-4>Have you ALTERed the databases to point the databases to their respective partners?
Ans>I am not clear with this question.
I am doing this porcess for the first time and I tried following steps from
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004_mem1,00.html
but it did not work
February 10, 2010 at 9:40 am
right click on the primary database, select properties, select database mirroring, follow the steps through the wizard.
A witness is not a requirement, up to you whether you require high availability mode.
---------------------------------------------------------------------
February 10, 2010 at 9:45 am
george sibbald (2/10/2010)
right click on the primary database, select properties, select database mirroring, follow the steps through the wizard.A witness is not a requirement, up to you whether you require high availability mode.
That is true, you could use the wizard. Only problem I have with that is you don't learn what needs to be done.
Since you are setting up a mirror between to instances on the same server, the first thing you need to do is setup the endpoints for each instance. Also, since you are the same server, each instance will need to use a different tcp port.
Look up CREATE ENDPOINT in books online. Post back the SQL you think you need.
February 10, 2010 at 9:46 am
Also, quick question, are the SQL Server instances running under a domain account?
February 10, 2010 at 10:33 am
Yes Both of them are on Same server and same Domain Control
February 10, 2010 at 10:41 am
Yes..They are on the same server and same domain
February 10, 2010 at 10:49 am
Have you started looking at CREATE ENDPOINT?
Are the two instances running under a domain account?
February 10, 2010 at 12:49 pm
Lynn is asking about the service accounts, not the host computer. Are you using domain accounts.
February 11, 2010 at 4:41 pm
Hi
Thanks for all the help I was able to make it work with Same Domain
Now I am trying between two domains
and I am getting the following error msg
TITLE: Database Properties
------------------------------
One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.
The syntax for a fully-qualified TCP address is:
TCP://<computer_name>.<domain_segment>[.<domain_segment>]:<port>
------------------------------
BUTTONS:
OK
------------------------------
Can anyone suggest me the way to fix this issue
Both the db server are in different networks
February 12, 2010 at 3:00 am
When setting up mirroring between 2 non-trusted domains you need certificates.
Search BOL or look at this article: http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx
HTH
Robbert
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply