October 9, 2015 at 4:41 pm
I have a SQL Server with multiple instances. One is 32-bit and the DB is over 60gb. And it seems to be slowing down my listers because of the 4gb memory cap. What is the easiest way to ugrade it to a 64-bit DB. All SQL 2008R2 enterprise on a 64bit os win2k8R2enterprise. Got dual HC procs and 144GB of memory.
October 12, 2015 at 2:47 am
I think that requires an uninstall-reinstall
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2015 at 7:07 am
Can I just uninstall the one instance as I have others being run on the same server?
October 12, 2015 at 7:36 am
Yes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2015 at 9:31 am
Ok thanks... is there a certain procedure I need to follow?
Also is there a way I can backup the instance fully so it knows all it login accounts and default values from the saved instance?
October 12, 2015 at 9:34 am
Run the installer, select the option to change or remove features, follow the dialogs. Make sure you select the correct instance to remove.
You can back up the master database. Providing you're going to reinstall with exactly the same instance name, it should be fine to restore the backup of master after reinstalling. You'll just have to go and change the max server memory afterwards. Back up MSDB and restore after the reinstall to transfer all your jobs, maintenance plans, etc
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2015 at 2:32 pm
Hello I am trying to gear up for this as I do not want to run into any issues. I have a week to come up with a solution.
Server:Windows Server2008R2 enterprise
144 Gb Memory 8ea. 300gb in RAID5
MSSQL Setup:
MS SQL 2008 standard (Master)(I believe this is the master DB)(being it was the first installed and later updated to SQL2008R2 enterprise.)
instance name: PCSP_SQL 64-bit ID: MSSQL10.PCSP_SQL ver. 10.3.5500.0(No longer used old Blackthorne DB)(I would love to delete it)(I think that requires a uninstall of 2008?)
Can I import/restore the 32-bit instance SIXBITDBSERVER into this DB and then detach the other DB and then rename the instance?
Or can I just uninstall the MSSQL 2008? Or will this break the other DBs?
Other 2 instances: ver. 10.50.1600.1
MS SQL 2008R2 enterprise
Instance name: SHIPWORKS ID:MSSQL10_50.SHIPWORKS 64-bit (used daily for shipping)
The instance I want to upgrade to 64-bit
Instance name: SIXBITDBSERVER ID:MSSQL10_50.SIXBITDBSERVER 32-bit (60gb DB for listing)
Well I'm not sure and have been doing a lot of reading now my brain is mush...
With the huge amounts of DB data I need to do this just once!
Can I create another 64bit instance named SIXBITDBSERVER and then detach/stop the running one and then restore the DB?
I' sorry for all the question marks! I realize this may be a lot answer
October 14, 2015 at 3:02 am
No, you can't have two instances with the same name.
You need to either:
Install a new instance with a different name, move the databases, uninstall the old instance, update all applications to look at the new instance.
or
Uninstall the old instance, install a new instance with the same name.
I don't understand your comments about the PCSP_SQL instance. Instances aren't master or otherwise. Master is a system database that each instance has. If you're changing the instance SIXBITDBSERVER, then you need to uninstall and reinstall that, and back up it's system databases. You don't need to touch any other instance.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 22, 2015 at 2:48 pm
Thanks for all the Help! I was able to get the instance uninstalled , as well installed and DB restored. Earlier you said, "You'll just have to go and change the max server memory afterwards." Just curious as to how this is accomplished? I see in the DB properties the same value as prior 0 to 21.4gb
other memory options 0 to 1024kb ... the only of those options that can be changed is the other memory options. Am I missing something??
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply