April 26, 2011 at 11:28 am
I have done mirroring before by testing it on two 2005 32 bit servers. That worked perfectly without a single incident. But now, I am trying to test the migration of 7 databases from a 2005 32 bit server to a 2005 64 bit one. That has given nothing but trouble.
The first attempt, it complained about the server network address lacking a fully qualified name (I did not give one on the other match-up). Once that was fixed it gives me an error 1418, it cannot find the 64 bit server. The server is easily accessible from the primary server. When I went to bring online the mirror database on the 64 bit server, it didn't let me saying that it was a mirror and I needed to remove it before I did that. I issued the ALTER DATABASE dbnameSET PARTNER OFF and it was fine to bring online.
I am creating a test database to continue working on getting this to succeed but I am baffled about what happened before. Can somebody explain what I did wrong before and how can I prevent it from happening again?
Your input would be greatly appreciated.
Best regards,
Eduardo
April 29, 2011 at 8:51 am
So, you're able to issue the SET PARTNER command on the mirror, but when you try to issue the SET PARTNER on the primary you get the 1418 error?
April 29, 2011 at 8:59 am
I am using the Wizard but that is basically what happens.
April 29, 2011 at 9:10 am
If you haven't already, take a look at this page, it deals with possible causes for the 1418 error.
I don't know of any inherent problems mirroring between 32- and 64-bit versions.
April 29, 2011 at 10:24 am
are you running the same edition ( standard + standard / ent + ent )
Can you find any in info in the errorlog files of both instances ?
How about capturing mirroring events ?
tcp/ip enabled ?
opened firewall ports for mirroring ?
Can you post @@version information of both instances ?
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply