SP x86 or x64?
I ran the following test on a machine (in SQL Server 2012):
SELECT @@Version
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (Intel X86)
Dec 28 2012 19:06:41
Copyright (c) Microsoft Corporation
Enterprise Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64)
I see that the operating system is x64 but SP1 is x86.
Question 1: Does this mean wrong SP1 x86 was wrong installation?
Question 2: Because I need to have SP3, Could I just install SP3 x64 or I have to uninstall SP1 x86 first?
Thank you.
SELECT @@Version
Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (Intel X86)
Dec 28 2012 19:06:41
Copyright (c) Microsoft Corporation
Enterprise Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64)
I see that the operating system is x64 but SP1 is x86.
Question 1: Does this mean wrong SP1 x86 was wrong installation?
Question 2: Because I need to have SP3, Could I just install SP3 x64 or I have to uninstall SP1 x86 first?
Thank you.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
To avoid any problem, could you please give somewhat detailed instruction how to uninstall sp1 x86 and install sp1 x64?
Thank you,
Mike
Thank you,
Mike
it is the type of sql server you have installed on your Server that determines 32 bit or 64 bit. SP should match your original installation of SQL not the OS
ASKER
re:> it is the type of sql server you have installed on your Server that determines 32 bit or 64 bit. SP should match your original installation of SQL not the OS
This will be my first installation ever. Someone else has doe the installations before and apparently has messed up installing x86 instead of x64.
Starting from start button, control panel etc. I could use some direction on locating sp1 x86 to uninstall it and then install sp1 x64 after downloading it.
This will be my first installation ever. Someone else has doe the installations before and apparently has messed up installing x86 instead of x64.
Starting from start button, control panel etc. I could use some direction on locating sp1 x86 to uninstall it and then install sp1 x64 after downloading it.
It is not the service pack that needs uninstalling, it is the entire SQL server. You will need to uninstall everything with SQL, then reinstall it all again with the x64 version.
The databases should all work the same.
The databases should all work the same.
Your sql server is 32 bit, I suggest, if possible install the 64 bit edition of SQL Server first (you need to uninstall 32 bit of sql server first ) . once you have 64 bit of sql saerver, you can install the 64bit edition of SP1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Is it that 2012 is not concerned or related to x86 or x64; this is SP version that determines whether it is going to be x86 or x64?
Mike