Solved

SQL Server hotfix folders

Posted on 2010-08-26
4
312 Views
Last Modified: 2012-05-10
Hello,

We are running a Windows Server 2003 Cluster with several SQL Server 2005 instances. I know want to move two disk resources from a SQL instance which is being turned down. I tested the process and the move into another cluster group works but there are some folders on one of the disks I am not sure about what I should do with them. Looks like they contain some hotfixes files. Can I simply delete them or will that somehow hurt us in the long run?

Thank you
Mc2102
8-26-2010-1-02-00-PM.png
0
Comment
Question by:Mc2102
  • 2
  • 2
4 Comments
 
LVL 4

Expert Comment

by:kjetilroe
Comment Utility

I assume that you have two different instances of SQL servers. One that is turned off, and one that where you move the disks to. As hotfixes probably are for the old SQL Server, and it will "die", I think I can safely say that those files can be deleted without any worry. Hotfixes are for the server, not for the database files.
0
 

Author Comment

by:Mc2102
Comment Utility
Yes you assumtions are correct but and the SQL instance will be shut down but at some point we want to use it again so the question is by removing these folders will the instance break?
0
 
LVL 4

Accepted Solution

by:
kjetilroe earned 500 total points
Comment Utility

I cant see any reason for the instance to break because of this. You might get into trouble if you want to uninstall some of the hotfixes, but usually that is not the case. The only reason for them being there are for uninstall purposes. So if you need to uninstall some of these hotfixes you might have to download and install them again to be able to uninstall them after deleting this directory.
0
 

Author Closing Comment

by:Mc2102
Comment Utility
Thanks - that was the information I was looking for.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now