September 29, 2008 at 3:33 pm
Hi, Was wondering if anyone has migrated a DB from 2005 32bit to 2005 64bit. . . I've never done it and was wondering if I could get a general overview of what was needed, issues, etc. We have a 2005 32bit DB and with the front-end being a C# web app.
Any decent documentation anywhere on what would need to be done?
September 29, 2008 at 3:41 pm
There is no migration path. It is not a migration, since engine is the same.
All CONFIGURATION changes that you might want to perform are falling into the category of removing AWE and increasing memory limitations on MIN and MAX memory settings.
September 30, 2008 at 3:34 am
Make sure you have 4 GB of RAM if you do not have 4GB of ram no use of migrating to 64 bit, backup the database before migrating, If it is mission critical database first migrate in test environment.
Here there is a document from microsoft http://www.microsoft.com/sql/techinfo/whitepapers/advantages-64bit-environment.mspx
Rajesh Kasturi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply