October 22, 2009 at 1:28 pm
Re the subject line. Any concerns about running 32 bit SQL Server 2008 on 64 bit Windows 2008 Server?
I have no experience with SQL Server 2008.
Thanks to all who respond.
October 22, 2009 at 2:37 pm
No concerns - other than why would you want to do that? There are only a very few specific reasons for running 32 bit SQL Server on x64. Most of those have to do with linked servers and accessing legacy systems that do not have 64bit drivers.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 23, 2009 at 7:57 am
This will be a vendor supported application. While they have certified the application for 64 bit Windows Server they have not yet done so for 64 bit SQL Server.
Thanks for the response, and the concern.
October 23, 2009 at 9:28 am
frovello (10/23/2009)
This will be a vendor supported application. While they have certified the application for 64 bit Windows Server they have not yet done so for 64 bit SQL Server.Thanks for the response, and the concern.
Typical - I've had this discussion with many vendors now. For some reason they believe their application will only work with a 32-bit version of the database running on another server. It is not true - but I know where you are at.
My recommendation - install the x64 bit version and only tell them if/when there is an issue that can be specifically directed to a problem with SQL Server. And, that does not mean their queries - but an actual issue with the database engine.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 23, 2009 at 11:14 am
I would take your advice and install 64 bit SQL, however it is not my call, but that of the application owner. And, to be assured of vendor support, we have to abide by their guidelines, so installing 64 bit SQL is out of the question.
On a side note, should the time come when the app is certified for 64 bit SQL, is there a SQL upgrade path from 32 bit or is a clean install required/recommended?
Thanks again for your response.
October 23, 2009 at 12:19 pm
There is no upgrade path from 32bit to 64bit. What you would have to do is install a new x64 instance and migrate the databases.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 23, 2009 at 12:47 pm
Jeffrey Williams-493691 (10/23/2009)
There is no upgrade path from 32bit to 64bit. What you would have to do is install a new x64 instance and migrate the databases.
Thanks, that should pose no problem if and when the time comes.
I'm outta here.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply