Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wickedhangover
Starting Member
5 Posts |
 Posted - 2009-03-09 : 12:19:36
|
| Is it possible to replicate and mirror from SQL 2005 Enterprise 64bit Edition to a SQl 2005 Enterprise 32bit Edition database server?We are implementing a failover system which requires that the backup mirror run the 32 bit edition. Due to software constraints we cannot run 64 bit. But we would like to run 64bit operating system and SQL on the primary database server.So I want to know for sure, can we replicate/mirror databases between the 32 and 64 bit environments? I know for sure that we cannot go from standard edition to enterprise. But I want to confirm that Enterprise to Enterprise will work whether it is 32 or 64bit. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-09 : 12:22:51
|
| Yes you can do it but will the mirror server hold the resources during failover as 32-bit has memory limitation compared to 64-bit. |
 |
|
|
wickedhangover
Starting Member
5 Posts |
Posted - 2009-03-09 : 12:26:34
|
| Well, my hope is that the failover would be for a short period of time that the limitations would have little impact to performance. We currently host all these databases in a 32 bit environment and they are fast. They are small databases all under 10gigs in size. So we are really looking to bring a new server online that is really fast and worst case we go back to what we are happy with now. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-03-09 : 12:29:23
|
quote:
Originally posted by wickedhangover
Well, my hope is that the failover would be for a short period of time that the limitations would have little impact to performance. We currently host all these databases in a 32 bit environment and they are fast. They are small databases all under 10gigs in size. So we are really looking to bring a new server online that is really fast and worst case we go back to what we are happy with now.
So are you using it for HA feature or something else? |
|
|
|
wickedhangover
Starting Member
5 Posts |
Posted - 2009-03-09 : 12:33:28
|
| Yes, and we're looking at different models for disaster recovery. We perform routine backups and could be back up and running in short order, but if we mirror to a downtime system and backup there then it puts us in a better situation for the way our servers are managed. |
|
|
|
|
|
|
Database Mirroring, Ent. 64bit to Ent. 32bit. ???