Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


uninstall default instance


uninstall default instance

Author
Message
Jpotucek
Jpotucek
Right there with Babe
Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)

Group: General Forum Members
Points: 790 Visits: 1648
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????



Jpotucek
Jpotucek
Right there with Babe
Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)

Group: General Forum Members
Points: 790 Visits: 1648
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!



Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14959 Visits: 38977
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!

Jpotucek
Jpotucek
Right there with Babe
Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)

Group: General Forum Members
Points: 790 Visits: 1648
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??



Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8784 Visits: 16558
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" ;-)
Jpotucek
Jpotucek
Right there with Babe
Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)Right there with Babe (790 reputation)

Group: General Forum Members
Points: 790 Visits: 1648
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.



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search