InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 14:09:39 GMT20http://www.sqlservercentral.com/Forums/Topic1372780-1549-1.aspxso 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:\MSSQL10_50.MSSQLSERVERDDI\MSSQL\FTDataF:\MSSQL10_50.MSSQLSERVERDDI\MSSQL\Logand I still have no idea what to do with the MS_AgentSigningCertificate file in the F:\MSSQL10_50.MSSQLSERVERDDI\MSSQL\data directory?? ultimately, I want to be able to drop the entire F:\MSSQL10_50.MSSQLSERVERDDI\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. Mon, 15 Oct 2012 13:09:39 GMTJpotucekhttp://www.sqlservercentral.com/Forums/Topic1372780-1549-1.aspxset the backup drive as a dependency on the sql server service resource and change the drives\paths on the sql server instance properties pageMon, 15 Oct 2012 12:57:02 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1372780-1549-1.aspxThis 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:\MSSQL10_50.MSSQLSERVERDDI\MSSQL\DATA to F:\MSSQL\MSSQLSERVERDDI\Data but I would also have to move the other folders (and files) as well:F:\MSSQL10_50.MSSQLSERVERDDI\MSSQL\FTDataF:\MSSQL10_50.MSSQLSERVERDDI\MSSQL\JOBSF:\MSSQL10_50.MSSQLSERVERDDI\MSSQL\LogF:\MSSQL10_50.MSSQLSERVERDDI\MSSQL\repldataand 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??Mon, 15 Oct 2012 11:59:30 GMTJpotucekhttp://www.sqlservercentral.com/Forums/Topic1372780-1549-1.aspxi 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:[quote][color="#FF0000"]Error Message:Msg 5178, Level 16, State 1, Line 1Cannot 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. [/color][/quote]but you can backup and restore with no problem.here's the path in facets to change the defaults:[img]http://www.stormrage.com/SQLStuff/facets_defaultPaths.png[/img]Mon, 15 Oct 2012 11:32:30 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1372780-1549-1.aspxSeems 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!Mon, 15 Oct 2012 10:54:07 GMTJpotucekhttp://www.sqlservercentral.com/Forums/Topic1372780-1549-1.aspxI 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:\MSSQL10_50.MSSQLSERVERDDI\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????Mon, 15 Oct 2012 09:35:27 GMTJpotucek