correcting MS SQL server
Posted on 2009-07-14
I have a dedicated Win 2K3 server for my SQL databases. I was running SQL 2K and using production DB. We had some outside consultants come in a install some different apps while I was gone. Nobody paid any attention... The consultants are gone and these "additioanl" apps have all been reinstalled on new servers with their own SQL server/DB, but my production server now has SQL 2K, SQL 2K5 and I think maybe even SQL express... adding insylt to injury, I am not sure if some of the good production DB that need to stay on this server are in 2K, or 2K5...
My guy feel is I need to move the "good" dabases off of this server, reload it (and install our newer license of 2K5), and then put the good DB back on to the server. Problem is (obviously), I am not sure what would be the best way to move forward. I have some extra hardware hanging out that I can temporarily use at this to make the correction.
Can somebody provide me a road map of what I need to do to determine what I have where, and how to correct this mess????