May 22, 2009 at 2:00 pm
I have yet to set up data mirroring so I have no experience with this. We are in the beginning stage of establishing a new Disaster Recovery model. The server administrator is hot on building servers with 64 bit 2008 Server. His question to me is "Can we data mirror from our 32 bit 2003 Server with SQL Server 2005 to SQL Server 2005 on a 2008 64 bit server".
Does anybody know if this is possible?
May 22, 2009 at 3:24 pm
The requirement, as far as I know, it that you cannot mirror from 2005 to 2008 or 2008 to 2005. As long as the databases are on the same version of SQL, you shouldn't have any problems.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
May 23, 2009 at 2:03 am
for upgrade reasons you can mirror from 2005 to 2008 but you can not failback
May 23, 2009 at 4:08 am
Jeffrey Williams (5/22/2009)
The requirement, as far as I know, it that you cannot mirror from 2005 to 2008 or 2008 to 2005. As long as the databases are on the same version of SQL, you shouldn't have any problems.
By design you can only mirror from 2005 to 2008 but once you failover to 2008 you cannot failback over tp 2005 to act as a partner. Since the database file structure is different.
May 23, 2009 at 4:14 am
Have not tried myself to mirror from 32 bit to 64 bit, but I'm sure this must be possible.
The process of database mirroring takes place at such a high level that there must be many layers of abstraction between it and the underlying x32 \ x64 hardware \ drivers.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply