uninstall default instance
-
I have 2 Windows 2008 R2 Servers that are clustered.
I am installing sql server 2008 r2 sp2 cu2 in the CLuster.
This is what i have done so far:
Install SQL Server 2008 r2 sp2 cu2 (slipstream) - I ran through the entire install for the default on Active Node of the windows cluster Server. I know that the next step would be to run setup again from the passive node and choose 'add a node..) but I would actually like to uninstall what I have done and start again. I set the path to my data and log files to F:\MSSQLxx_xx.MSSQLSERVER\MSSQL\DATA and I would like change that so I thought the easiest way would be to uninstall/reinstall.
Do I just uninstall SQL Server from add\remove programs? or do I have to do something in the Cluster Administrator first to release the cluster resources????
-
Seems like I have several options, but I'm not sure which to take.
uninstall sql server from add\remove programs?
(not sure if this will release the cluster resources - eg the drives that have already been assigned to this instance)
Launch SQL Server setup - go to maintenance screen and do a remove Node?
Go into Failover Cluster Manager then click Nodes and delete the Sql server Instance then uninstall SQL Server??
so confusing!
-
i think it might be easier to jsut change the default paths for the files and backups, wouldn't it?
I did basically what you are saying to another server recently;
added a nice 3 terabyte drive, and changed all my default paths to use the huge drive.
a "gotcha" to watch for that was a little annoying: the new drive was formatted with 4096 sized sectors, where the original drive was foramtted at 512.
as a result, i could not detach, and reattach, because youy get an error saying this:
Error Message:
Msg 5178, Level 16, State 1, Line 1
Cannot use file % because it was originally formatted with sector size 512 and is now on a volume with sector size 4096. Move the file to a volume with a sector size that is the same as or smaller than the original sector size.
but you can backup and restore with no problem.
here's the path in facets to change the defaults:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
This is a brand new install and I did think of just changing the default drive paths and moving the system Database data and log files from their current path of F:\MSSQLxx_xx.MSSQLSERVERDDI\MSSQL\DATA to F:\MSSQL\MSSQLSERVER\Data but I would also have to move the other folders (and files) as well:
F:\MSSQLxx_xx.MSSQLSERVER\MSSQL\FTData
F:\MSSQLxx_xx.MSSQLSERVERI\MSSQL\JOBS
F:\MSSQLxx_xx.MSSQLSERVER\MSSQL\Log
F:\MSSQLxx_xx.MSSQLSERVER\MSSQL\repldata
and I have no idea what to do with the MS_AgentSigningCertificate file in the data directory.
This is our first cluster - and will be the template for our production cluster so I want to do it right the first time.
Do you think if I uninstall SQL Server from Add\Remove programs and then remove the instance from Cluster Manager that I should be able to start fresh??
-
set the backup drive as a dependency on the sql server service resource and change the drives\paths on the sql server instance properties page
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
-
so once I set the backup drive and change my default paths, AND move my master, model and MSDB data and log files, I will still have files in the following folders??
F:\MSSQLxx_xx.MSSQLSERVER\MSSQL\FTData
F:\MSSQLxx_xx.MSSQLSERVER\MSSQL\Log
and I still have no idea what to do with the MS_AgentSigningCertificate file in the F:\MSSQLxx_xx.MSSQLSERVER\MSSQL\data directory??
ultimately, I want to be able to drop the entire F:\MSSQLxx_xx.MSSQLSERVER\MSSQL folder structure and really clean it up.
just seems easier to me to re-install, I just don't know if the simple act of uninstalling SQL Server will release the drives that I assigned to this Instance back to the cluster as available.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply