June 5, 2008 at 5:45 pm
Hi,
Can anybody clarify me on the following doubts. its very urgent.
1. How to determine the sql server installed is 32 bit or 64 bit
2. can i restore the master database of 32bit to 64bit.
3. can i restore the otgher system databases of 32bit to 64bit.
Iam running sql server 2005
Thanks
Chandra Mohan N
[font="Verdana"]Thanks
Chandra Mohan[/font]
June 5, 2008 at 6:33 pm
Hi Chandramohan,
1. I think Select @@version will tell if it is x64 or x86
2. For restoring system databases you need to have the same build and same edition of Sql Server refer, http://support.microsoft.com/kb/264474
So I think you can restore master if you have the same build number.
3. Same as above..
[font="Verdana"]- Deepak[/font]
June 5, 2008 at 7:55 pm
You cannot restore your master from a x32 to x64, but you can use http://support.microsoft.com/kb/918992/ MS article to move your logins to the new instance (How to transfer the logins and the passwords between instances of SQL Server 2005)
All configurations at the instance level should be re-done manually. Also please be aware that you may want to assign "lock pages in memory" permission to your sql server service account once running x64.
Hope this helps.
June 5, 2008 at 10:25 pm
[font="Verdana"]1.) Use the below query to check.. If its X86 then 32bit else 64bit
Exec xp_msver 'Platform'
2.) No you won't be able to restore 32-bit to 64-bit. You need to re-create all the logins, linked server etc
3.) None of the 32-bit system databases can be restored in 64-bit.[/font]
Regards..Vidhya Sagar
SQL-Articles
June 6, 2008 at 7:05 am
Thanks michaela and Vidhya for correcting me..:)
[font="Verdana"]- Deepak[/font]
June 23, 2008 at 12:29 pm
I'm interested in this. In knowledge base article 264474, Microsoft is talking about builds.
They also suggest SERVERPROPERTY('ProductVersion') as a method to check this.
Have you seen any references about editions (Standard / Enterprise) and platforms (X86 / X64 / IA64)?
In the knowledge base article, it also says that you can use RESTORE HEADERONLY to check the build of a backup. This does however only give you information about the build, not the edition or platform.
Ola Hallengren
June 23, 2008 at 7:02 pm
Hello Ola,
Sometime back when I tried to restore msdb from developer edition to enterprise edition and the error message was that edition was not supported.
[font="Verdana"]- Deepak[/font]
June 24, 2008 at 10:24 am
Thanks, Deepak.
What about restoring master from 32-bit to 64-bit and the opposite?
Has anyone tested this or have you seen in any document that it's not supported?
Ola Hallengren
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply