July 5, 2011 at 7:44 am
i am working on a 2005 to 2008 sql R2 migration.
i would like to use simple mirroring (without witness server).
one of the issues i am having is with the SSIS packages which refer (hard coded) to machine name "DB1" - what happens in a scenario where the primary DB server goes down and i want the mirrored server to take over?
the SSIS' will look for the name "DB1" which isnt available. the mirrored server is named "DB2".
during such a scenario, would i need to rename "DB2" to "DB1" ?
i read some articles about changing machine name and it doesn't look a seamless process.
when the primary server is fixed, how do i go back to the original name?
thank you
July 5, 2011 at 2:54 pm
you would have to rename the server, which as you say is not a seamless process to do properly. It also means before you start mirroring back the other way you would have to rename the original server, and then rename it again at the next failover. So, the outage of a failover is lengthened and its a complete PITA.
SSIS packages should never have the connection string hardcoded. They must be changed to use an alias or an external reference (such as an xml file). Its not that difficult to do and in your situation is a must.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply