Post reply

Upgrading OS Need Suggestions

  • June 2, 2010 at 12:44 am

    #225214

    Dear all,

    I have xp professional 32bit OS & sql server 2008 Standard editions

    now we have planned to increase of RAM, If i changed the 32 bit OS to 64 bit OS, After that can we attached the

    Old MDF& LDF in to new OS..?

    Is there any problem will occur while i moving the DAtabase 32 bit OS to 64 bit..

    Any Precautions we have to take...

    Please tell me your suggestions..

  • June 2, 2010 at 6:44 am

    #1175249

    I would use backup and restore instead of attach DB. This works 100%.

  • June 2, 2010 at 8:23 am

    #1175327

    I don't know if there will be a problem if you move your databases without changing your SQL Server install from 32bit to 64bit. Have you upgraded the SQL Server edition or are you planning to?

    I advise testing the move on a sandbox server (or dev server) before doing it for real. That way you know for a fact if you'll have problems.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 3 posts - 1 through 2 (of 2 total)

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