November 24, 2010 at 6:23 am
We're in the process of moving our web site to a new data center. Currently our databases are mirrored between 2 servers (W2k3 + SQL2k5) with a witness on a 3rd server. Our new data center will use a 2-node cluster (W2k8 + SQL2k8). I've created a VPN tunnel between the 2 data centers to help facilitate the move. As an interim step, I'd like to change the mirroring so that one of my current servers mirrors the databases to an instance on my cluster. This will simplify my migration and shorten the switch-over time. I haven't found any gotchas regarding this, but thought I'd ask if anyone is aware of any special considerations I need to take.
Thanks
BigSam
November 24, 2010 at 7:07 am
just remember to script out your logins, server roles, SQL Agent jobs and SSIS packages (if any).
November 24, 2010 at 3:36 pm
I'm not sure if this applies to SQL 2008 but I was bit by this doing a rolling upgrade from SQL 2005 to SQL 2008R2.
If you plan on using the SQL 2005 server as a quick back out plan by bringing it back online after the failover and mirroring is broken it may be upgraded to SQL 2008 and you cannot bring it online.
The workaround for this is to stop SQL on the 2005 instance to trigger the failover so the SQL 2005 db can't be upgraded to SQL 2008.
The bug has already been reported on connect.
November 28, 2010 at 7:44 am
Good tip. I had forgotten SQL the logins needed to be 'replicated' 1st.
November 28, 2010 at 10:37 am
Good advice above. As long as you move all non-db stuff (logins, linked servers, jobs, alerts, etc.), and the mirroring sets up, you ought to be fine.
Note that log shipping, with decreasing log backup intervals can work as well if mirroring is hassle. Restore log backups quicker and quicker to get close and then do a stop on the first server (set restricted_user works well) then a final backup and switch over.
Don't forget that clients might need help switching over. They may not be set to automatically move to the mirror server on switchover, depending on how you have set the connections.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply