Steps for
setting up a SQL Server 2005 mirror - pretty slick!
I watched Kimberly Tripp’s webcast the other day
on database mirroring because I have wanted to set it up but have really had no
reason to. Aside from some good information, this gal is a super dynamic
speaker, very clear and concise with her explanations, and a real asset to our
SQL Server community! (I think I have a new favorite). Anyway, after watching
this thing, I immediately decided to delve in and create my own. Actually, I started
on it before the webcast had gotten halfway through. Probably not a good idea,
I started getting errors right off the bat. Upon “googling” for a solution, I
came across a thread on MSDN forums. This got me straightened out and I got it
set up no problem; I have included the link below, so check it out. It provides
a “1,2,3” step-by-step which I was going to rewrite but decided that it was not
necessary. This one will suffice.
One thing that I would add: you can use the old
Telnet for making sure that your endpoints/ports are available. At the
command prompt, type the following:
telnet <FQDN> <port number>
For my example I tried the following:
Slight problem here – that’s the wrong port. I
tried this, then:
And got this:
In this case, a blank screen is what you want.
You are able to connect here, so the port is definitely open. Make sure and do
a select * from
sys.tcp_endpoints to verify correct port number if necessary. Reading the link included below, pay careful
attention to the CREATE ENDPOINT, ALTER ENDPOINT START, and SET PARTNER
statements. These are critical. For some reason, in SQL Server Management Studio, this wasn’t happening for me. Switching over
to TSQL, however, did the trick.
Lee
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=258365&SiteID=1
------------------------------
Nothing like having AdventureWorks mirrored and available, right?
fd7274fd-d2f0-48b6-8c90-63e46ccc61b8|1|5.0