Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

uninstall default instance Expand / Collapse
Author
Message
Posted Monday, October 15, 2012 9:35 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 1:33 PM
Points: 764, Visits: 1,581
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????



Post #1372780
Posted Monday, October 15, 2012 10:54 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 1:33 PM
Points: 764, Visits: 1,581
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!



Post #1372832
Posted Monday, October 15, 2012 11:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:09 AM
Points: 12,965, Visits: 32,541
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1372850
Posted Monday, October 15, 2012 11:59 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 1:33 PM
Points: 764, Visits: 1,581
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??



Post #1372865
Posted Monday, October 15, 2012 12:57 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:04 PM
Points: 6,765, Visits: 14,429
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"
Post #1372908
Posted Monday, October 15, 2012 1:09 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 1:33 PM
Points: 764, Visits: 1,581
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.



Post #1372913
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse