locked
Reinstalling OS RRS feed

  • Question

  • I have a 2008 Standard server that Im needing to reinstall so I can get it to 64bit.  I have several SQL databases on it.  Can I just create .bak files of them, reinstall the OS, install the roles and SQL 2008 and restore them to the same instance?  They are currently SQL 2005 databases.  Little nervous to start this process....
    Friday, September 13, 2013 4:04 PM

Answers

  • So to be clear on what you're looking to do:

    1. Backup SQL DBs from existing 32bit SQL2005 server
    2. Wipe out the existing OS on the server
    3. Install Win 2008 Std x64
    4. Install SQL 2008 (R2?) x64
    5. Restore the DB backups you took in step 1

    I do believe, if that is what you intend, that it would work as described.  The only things to watch out for would be if you have any applications on the server that might not play nice with x64.

    One other thing, though.  Don't call this an "upgrade" I think that's where some confusion is coming in.  Upgrade implies taking what is already on the system, and making it the newer / upgraded version.  You are, for all intents and purposes, loading a "new" server from the ground up, and restoring your DBs to it.


    Jason A.


    • Edited by Jason A_ Friday, September 13, 2013 5:28 PM
    • Proposed as answer by Shanky_621MVP Saturday, September 14, 2013 7:56 AM
    • Marked as answer by Allen Li - MSFT Thursday, September 19, 2013 1:06 PM
    Friday, September 13, 2013 5:26 PM

All replies

  • Unfortunately its not simple because 32bit SQL architecture is different to 64bit  architecture. it will be full migration you have to do.

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Friday, September 13, 2013 4:25 PM
  • Are there any white papers on how to do that?
    Friday, September 13, 2013 4:28 PM
  • Treat it as brand news server setup

    http://www.microsoft.com/en-gb/download/details.aspx?id=24662

    vt


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    • Proposed as answer by Shanky_621MVP Saturday, September 14, 2013 7:56 AM
    Friday, September 13, 2013 4:34 PM
  • Even if its on the same server?  Im having to upgrade not only the OS to 64bit, but also an upgrade of SQL from 2005 32bit to 2008 64bit....
    Friday, September 13, 2013 4:45 PM
  • It is not possible to upgrade 32bit OS to 64bit OS for that you need to wipe out 32bit os on the system right..?

    If keep same server name and install sql exactly as it was on 32 os. may be backup/restore option would  work but this is an high risk approach

    I haven't such type of upgrade b4.

    vt

     


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Friday, September 13, 2013 4:52 PM
  • So to be clear on what you're looking to do:

    1. Backup SQL DBs from existing 32bit SQL2005 server
    2. Wipe out the existing OS on the server
    3. Install Win 2008 Std x64
    4. Install SQL 2008 (R2?) x64
    5. Restore the DB backups you took in step 1

    I do believe, if that is what you intend, that it would work as described.  The only things to watch out for would be if you have any applications on the server that might not play nice with x64.

    One other thing, though.  Don't call this an "upgrade" I think that's where some confusion is coming in.  Upgrade implies taking what is already on the system, and making it the newer / upgraded version.  You are, for all intents and purposes, loading a "new" server from the ground up, and restoring your DBs to it.


    Jason A.


    • Edited by Jason A_ Friday, September 13, 2013 5:28 PM
    • Proposed as answer by Shanky_621MVP Saturday, September 14, 2013 7:56 AM
    • Marked as answer by Allen Li - MSFT Thursday, September 19, 2013 1:06 PM
    Friday, September 13, 2013 5:26 PM