Post reply

SQL 2005 64-bit failover to 32-bit

  • March 9, 2009 at 8:39 am

    #128794

    If our production server that is running SQL 2005 64 bit (Win2003) fails, could we use a SQL 2005 32 bit (Win2003) as a backup/failover?

  • March 9, 2009 at 9:46 am

    #956143

    Do you mean in a cluster, or with log shipping?

  • March 9, 2009 at 9:49 am

    #956150

    This would be for a clustered environment. Thanks

  • March 9, 2009 at 9:55 am

    #956157

    I always thought that in a clustered environment both nodes needed to be the same? If one node is 64-bit, the second (and additional) node(s) needed to be as well.

  • March 9, 2009 at 10:12 am

    #956174

    Clustering is at instance level...that is your 64 bit edition instance running on node1 will failover to node 2 if for some reason the the node 1 can no longer function correctly. In affect the same 64 bit instance will start up on Node 2. So no you cannot intermingle 64 and 32 bit versions

    As for the other high availability options such log shipping, that should work ok. Databases on 64 bit and 32 bit are interchangeable. That is you can restore a db created on 64 bit editions to a 32bit instance. I have previously maintained a DR server on 32 bit edition of sql server on a remote site log shipping databases sitting on 64 bit sql cluster.

    DB mirroring I'm not sure about, but as failover is at database level not instance level like clustering and is pretty much an extension of log shipping then it should work.

    Gethyn Elliswww.gethynellis.com

  • March 9, 2009 at 11:24 am

    #956235

    I have done log shipping between 64 and 32 bit, that works just fine.

  • March 13, 2009 at 6:45 am

    #959043

    Thanks for all your replys, they were helpful.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply