mibuso.com
Home› SQL General
Options

Installing SQL 2005 64bit on 32bit OS for testing purpose?

Alex_ChowAlex_Chow Member Posts: 5,063
edited 2007-06-27 in SQL General
Is it possible to install SQL Server 2005 64bit version on a Windows Server 2003 32bit server? Will SQL Server 64bit stop installation on a 32bit CPU?

This is just for testing and is not going to be used in the production environment.
Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work

Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book

Comments

  • Options
    davmac1davmac1 Member Posts: 1,283
    No
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • Options
    DenSterDenSter Member Posts: 8,304
    Alex, I thought what you wanted to do is have a 64bit prod environment, and a 32bit test environment, and you were asking if you could use a database backup from one and use it on the other. You'd have to install 64bit SQL on prod and 32bit SQL on test, because the 'bitness' is not compatible with each other, the software bitness has to match the OS bitness.

    The question would then be: can I use a database backup from my 64bit environment and restore it into my 32bit environment.
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
  • Options
    Alex_ChowAlex_Chow Member Posts: 5,063
    DenSter wrote:
    Alex, I thought what you wanted to do is have a 64bit prod environment, and a 32bit test environment, and you were asking if you could use a database backup from one and use it on the other. You'd have to install 64bit SQL on prod and 32bit SQL on test, because the 'bitness' is not compatible with each other, the software bitness has to match the OS bitness.

    The question would then be: can I use a database backup from my 64bit environment and restore it into my 32bit environment.

    Oh ok, thanks for the correction. :wink:
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • Options
    bbrownbbrown Member Posts: 3,268
    The database does not differ between the 32 and 64 bit versions. Moving databases between the versions is not a problem. In fact, we have a mirror running with a 64 bit primary and a 32 bit backup

    64 bit SQL must run on 64 bit Windows

    32 bit SQL can run on 32 or 64 bit Windows
    There are no bugs - only undocumented features.
  • Options
    WaldoWaldo Member Posts: 3,412
    bbrown wrote:
    The database does not differ between the 32 and 64 bit versions. Moving databases between the versions is not a problem. In fact, we have a mirror running with a 64 bit primary and a 32 bit backup

    I can confirm this! :wink:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    DenSterDenSter Member Posts: 8,304
    I thought it would work, I just wasn't sure. Cool :mrgreen:
    Daniel Rimmelzwaan
    RIS Plus, LLC
    MVP - Business Apps
Sign In or Register to comment.